Can somebody help me with the IF formula here please? I want to match Column K and Column O with No as the select values. I’ve tried =IF(K6=O6=“No”, ”match”) but it didn’t work. Thanks in advance for your help!

Why is twitter down by 5% today? Good buy at this price?

Is it typical for UK companies not to cover the cost of visa sponsorship and to assume that the international applicant knows that they will have to fund the process themselves without telling them?

Any experience with MBAs at SKY schools in Korea (SNU, Yonsei, KU)? Is it worth it? Difficulty of getting in?

How could we become better educators?
What do teachers do to make you think maybe they shouldn’t be working with kids.

I am planning to move from fintech to consulting after 2.5 years of work ex. Was curious how the pay and bonuses are like at top consulting firms like Deloitte/pwc/KPMG for software development roles

Is the best office chair the Herman Miller Aeron?

Does anyone know the entry level salary for Project Manager at Epic Systems? Its located in Wisconsin. Thank you!

Hi! How is work life balance for business ops/strategy roles at Facebook or Google? Are 60+ hour weeks common?

Are there dream interpreters in the city? 🫠🤔

Has anyone gotten their dreams interpreted?

What is the best way to position myself when trying to make a switch from litigation to transactional?

There's no safe team with work/life balance to hide. The work will find you.

How much is the joining bonus for a manager at ZS? Also what's the CTC range I can expect with ~10 years experience?

Has anyone used All In One Poster Company for their Labor Law posters? If so, would you recommend?

What is the expected salary of front-end web developer? 7 YOE in Quebec. I feel like I am being underpaid

What is the salary range for a clinic manager at Parkland Hospital at Dallas, TX?

If you’re freelance/contract to hire and it’s been three months and there’s been no conversation, what does that mean? Don’t rock the boat? I don’t want to become a FT employee but no clue when and if the ace is gonna come down. Any insight?

For people changing companies recently, what was your reason for leaving and why did you choose where you went?

How do I highlight a time period area in an excel line chart?

Good morning! I need help parsing emails and adding data to an excel spreadsheet using Power Automate. Can someone here help me out?

I have a crappy spreadsheet that I’m trying to make more appealing or easier to digest. What would be the best way to do so? I have locations, first name, last name, start date, end date, dob, and comments as the rows and columns have the details. I’m trying to get the dates to show up in the pivot chart instead of a value of that makes since. What would be the way to go about this.

Named Ranges. Is this efficient on the system? Is it a no no to have a named range reference an entire column like A:A?

Is there a way where I can sum up the value by categories ( say L/M/H) for each section?

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Urgent 🥲 How to show a low to high range on a graph in thinkcell? Any ppt or excel suggestions will work

Whenever I press Enable Content, Excel crashes (and does an infinite loop). I can’t seem to break link the cell that is supposedly linked to an external source. Anyone know how to solve this?

I have a formula referencing a cell in another tab its a grand total amount. And i have a list of company codes that need to be added and removed. When i delete rows it creates a ref error. How do i prevent this?

Let's say I have hundreds of rows of data. Each row is related to one of ten products. On a different sheet, I want to have a row for each product with a variable number of columns in each row

I’m doing a class sign up via a form auto workflow from Microsoft form to excel. In my excel workbook, I want to auto update a separate sheet with the classes folks opt to sign up for. How do I create a lookup for if x text in one cell is true (ie name of the course), then it gives the name of the person in a separate column. Is this an index match match? And can I do this as data is continually coming in?

Any advice on good keyboard models for comps analysis? We use factset, so bloomberg terminal keyboard is out. Thanks!

Is it possible to have a table where the first 8 columns are pulled from a source in Power Query, and the next 6 columns are “data entry” items where I can fill in information based on what the first 8 columns show?

Anyone else jump to conclusions about a person’s competence simply by the number of merged cells in their workbooks?

Need to count attendance per office location. Looking for cell formula that gives me live view of “yes” (attendance) when attendee is assigned to “x” office. Keep trying IFS but getting 0.

How do I use formulas that reference a pivot table without copying and pasting the pivot as values?

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

Looking to develop an excel fillable form that will export results to an interactive dashboard. Ultimate goal is to export forms from multiple files (~200 per Year) into single interactive dashboard. Any specific suggestions on where to begin? Next stop is YouTube. Thx.

When using a calculated field within a pivot table with the following formula: IFERROR(GM/‘Total Sales’,”-“), my values still return a VALUES error. I tried adding an additional parenthesis but no luck