I need help writing an OFFSET formula that will 1) return the array of numbers below including the blanks in the correct order and 2) be dynamic such that if I add the number 11 either in the cell directly below the 10 OR below the 10 but with blank cells between will continue to pull the full array including blanks up until the 11. I know how to do this if there are no blanks, but the blanks present an issue because I can't combine the usual OFFSET with COUNTA functions.

Any recommendations for residential areas/ accommodations close to EY london office? Hate to commute🫠 starting soon!

Has anyone successfully moved out of claims into underwriting? I have been doing worker’s compensation claims for about 9 years now as an adjuster. I would really like to get into underwriting but have not had any success so far. What are some other roles I can transition to?

Hi. I have a Panel Interview with a Salesforce product company. I need to do a presentation to the customer on the Product and how it will solve their problems. I need to do an elevator pitch for 3 slides about the company and then address the customer problems with the features of the product. Can you please share some Tips on these ( Elevator Pitch about the company and suggestions for the Panel interview) ? Thanks.

How much should I invest in buying a HOME as my primary residence.

Current TC: 200k
Net worth: 300k, readily available 170k in stocks, hysa and cash
Current rent: 2000 per month
Age: 30

Wonder if anyone has any excel model or a rule to determine how much I can afford or should go for?

What’s your target retirement number and at what age do you plan to retire?
Of course I know it depends on a wide range of factors, but I’m curious to get a sample from this group.
Mine is $5M at 55.

24 F, Arab living in Ohio. Hijabi, don’t drink, don’t smoke. Interested in Arab men. Willing to relocate in the US or to the gulf countries.

What would you folks say is the best and most achievable route to take for true Program Manager (minimal tech exp) with Sec+, picking up CISSP, and wanting to get more into the technology? Thoughts?

Hey Guys, Currently I am having 16.12 lac pa in current organization and 5% Bonus So total comes around 16.93lac pa. Nagarro is asking me to rejoin at 20 lac pa (5% Project bonus included).
When I left Nagarro around 2 years back my fixed there was 11.50. Shall I consider this offer of Nagarro. Reason I want to change the job is because I don't have code based automation in my current organization and I have been an SDET in my whole experience.

Are there any onsite opportunities in nagarro

I got 2 times in Nagarro cheerboard. For Sep and Nov month.

Will this be beneficial in appraisal?
BTW 2 Cheerboard ka bas 1000 rs mila
😭😭

Anyone got the skinny on Alix consulting?

Got pinged by a recruiter for an MD role in digital transformation

He claims they compete with MBB and Alvarez.

Thoughts?

For people who recently refinanced, bought or is in the process of buying a new home, what APR did you get?

Can we take leaves while serving NP?

For people who post links to news first - how do you do it? I send stuff to people and they're like oh saw that, and it was two hours ago...

Literally all of my LinkedIn connections are recruiters lmao

Hi everyone! Does anyone have suggestions on a good standing desk or ergonomic chair?

Any trans in this bowl from India ?

Gave AUD on Wednesday and my exam was VERY hard. 4 sims with exhibit were very lengthy and complicated and one sim I had no idea what it was asking(never seen it before). Very nervous for the result as this was my 2nd try. 😭

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?

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

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

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.

How do you fix microsoft excel cannot paste data error?

Would anyone be willing to teach me vlookup?

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 an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

What are your top Excel ninja tricks? Ones that few people know...

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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

Any book recommendations on excel modeling for real world business applications?

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.