How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

I got a follow up call on an application for a "Remote" position. Talked to the recruiter and was told they planned a mandatory return to the office in the next year and the position was only "Remote" until then. Has anyone else see this?

What’s in welcome kit for the new joinees ?
What’s the update on office opening ?

If you had the pick of BCG Chicago and Bain Chicago out of undergrad, which would you choose, and why?

Hey All,
Exp : 8.6
Exp On Mulesoft : 4.8
CTC : 20 LPA
Offer holding :
31 Fixed Infinite Computer Solutions
32 fixed from @Nahil (Saudi based gave 32 fixed (no TDS))

Current company: Infosys
I am waiting for the offer letters from
EPAM Systems asked 35, but selected for D3 role so 31/32 LPA.
Genpact (Enquero global) asked 35, not sure they can give or Match?

Which one to join, I am planning for long term commitment. Please provide your thoughts.

Senior Manager Retail at Apple anyone?
Wondering what a SM would do in retail, by exiting from consulting.
Got interview next week.

Hi, can someone help me understand what's the salary range for a UiPath business/process analyst with 5 yrs of experience in UiPath and overall 10 years of experience in Toronto, Ontario?

So anyone Opting In??

Those who tuned into KPMG town hall, thoughts?

Anyone have examples of companies started by ex-VC investors (Associate-VP level)

What is everyone's long-term career goal with the clinical research field? What do you hope to be doing in 10-15 years?

Anybody could refer me to Deloitte.
I'm happy to refer anyone to EY as well.
Thank you

Friday Wordle

Wordle 265 6/6

⬛⬛🟨⬛⬛
🟨⬛⬛⬛⬛
⬛🟩⬛⬛⬛
⬛🟩🟩🟨⬛
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩

Would you rather have 5x amex MR points or 3x chase UR points for each dollar spent on flights? Why? Company let's me book flights on personal cards and trying to decide which to choose.

Anyone work for Kraken? If so what are some pros/cons about the company? I work financial crime investigations, and had a recruiter reach out about a law enforcement production job. Opinions on salary, PTO, and other benefits would be helpful!

I've been working at my current job for about a year now and I'm finally beginning to understand how the company works.

It's not easy, though. It's a small company, which means there are only a few of us in each department. There is no dedicated training team, so we all have to learn new things on the fly through trial-and-error or by asking our coworkers for help. The management team seems to be pretty hands off when it comes to project management and project direction, so it's up to us engineers to figure out how we want to spend our time and who we want to work with.

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

Still don't have xlookup. #fomo

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

Best websites to get more of a handle on Excel as a beginner-intermediate?

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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)

How do I compare two sheets to make sure they are identical?