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

Diamond medallion on Delta. They lost my bags on the outbound (3 with my wife who is Plat) and inbound flights (1) on a trip to Europe. How many points should I expect? Any advice to deal with this?

Those in Orange County, senior or manager. Anyone interested in Capital group? They are in Irvine and hiring.

EY leave department hasn’t been the most helpful with the exact details around maternity leave - so just wondering for any EY mamas - how do we initiate getting the two weeks before due date off? Just a doctors note or ??? Thank you!!

Any thoughts on iCapital?

Do OPTUM gives reimbursement for broadband installation?

When will the salary be credited in Optum.

What is meant by a "Lateral Hire" in Infosys?

Hey Fishes,

Currently I’m looking for an opportunity with Big 3 firms.

Presently working with a Big4 firm.
Yoe : 5 years (before MBA)
Qualification : BE, MBA (tier 1)

Hi @AIRBUS fishes, Can someone throw some light on the the different grades/designations ? I see E4 , Technology Lead mentioned in my offer letter.

I am reading "the 48 laws of power" by Robert Greene and wondering whether it still applies in today's corporate world.

Any companies hiring for Forensic Accounting (Investigations, Litigations, AML, etc.) I have both my CPA and CFE.

Hi Fishes,

I have offer from Accenture/Fujitsu/Capgemini of almost same package. Please suggest which organization is better to join as an IT senior analyst?

Does anyone else struggle with their significant other not understanding the nature and demand of our work? We constantly fight about me staying late and blames it on poor time management.

Does anyone use SketchUp? Thoughts? Advice?

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

Hi Fishes,
Have potential opportunity at HSBC EDPI.
Just wanted to know how much can I ask for GCB5 AVP Business Analyst role?
YOE - 6 Years
CCTC - 20 LPA
Also how long does it take to move from AVP to VP and how are the yearly hikes?

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

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”

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

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

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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 websites to get more of a handle on Excel as a beginner-intermediate?

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

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?

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

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.

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

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 😭

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

Would anyone be willing to teach me vlookup?

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?