Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

A summer associate has a side hustle business. It’s ok until they are barred right?

What is everyone’s top 1 or 2 favorite books on personal finance? I’m always looking for a new one to bring into the fold of what I’m doing

anyone leave consulting to do something radically different and loved it?

Guys please suggest which company should i join
Optum(uhg) - 22 Lpa
IBM - 22 Lpa
Epam Anywhere - 24 lpa
YOE : 6.2yrs
~TIA

Spotify has a couple of really interesting remote first-positions open. What’s their salary range at Director level in EU?

Why does insulin in the United States cost 10x what it costs in Canada?

Are people still live on here? I was diagnosed last year with ADD and I’ve tried two stimulants so far. I know they aren’t meant to be a magic pill but I’m still struggling with general tasks and feel like I’m doing the bare minimum. The Nurse has suggested I try non stimulants. What are peoples experiences with meds ? Did they work or not?

How do y’all deal with people at work who are stuck on stupid? Like they have no idea what they’re talking about and they REFUSE to learn. It’s like they have a god complex or something even with proof, maybe bc of their tenure at the company? Even if there’s valid data backing up that they’re wrong. Maybe it’s bc I’m a type 8 enneagram, but it frustrates the hell out of me!
So any advice would be lovely :)

M&A tax manager 1 salary in NYC ?

Hello Future Sharks,

No response from Ericsson HR, after salary discussion. Even he confirmed the salary break up over mail. Is it common practice thr. Was very excited to join the organisation

Is anyone from this bowl working at 6sense?

If yes, please share some info regarding work culture, Work life balance, job security and employee benefits.

Thanks in advance, fishes.

Is it 72 hours within embarking travel to India or 72 hours prior to landing in India for negative PCR test? Need to book but want to be sure.

What's a nice restaurant to take relatives to when they're in the city visiting? Would like something nice but not over-the-top fancy.

Welcome everyone to this EY - UK bowl. Please feel free to invite friends and 🐠 fellows from UK practice. I encourage to share your experiences and contribute with those that are looking for insights and recommendations!

Why are markets up today ? Has the panic subsided?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

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

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

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!

Still don't have xlookup. #fomo

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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)

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.

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.

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

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