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

Has anyone transitioned out of immigration law?

Third year associate at an AmLaw 100 firm (non Frag or BAL, but doesn’t pay market), and I feel that growth is severely limited in this field.

Hi there! What’s the best way for a Dreamer to get their citizenship? I’ve renewed my AB 540 multiple times and would like to get the ball rolling on my citizenship. The Biden Admin talked about providing a pathway to citizenship for Dreamers but because of the pandemic, they decided it wasn’t an important enough issue to discuss.

What is the overall sentiment of the talent pool in Toronto? IMO There are a lot of questionable people in this market, how are they employed?

Hi Folks,
What is job security and stability in Cyber security consulting practice in EY . One of my friend got offer with 50% raise to what he is currently taking, he is on H1-B , he just want to be on safe side before making move. Appreciate your quick response.

My current company is “taking me off payroll” but instead of laying me off or firing me, are fully expecting me to take up an hourly contractor position for $30/hour with no specified time or guarantee of hours. How do I respectfully tell them no?

Hey Guys,

How is it like working for Goldman Sachs? Currently interviewing with them for SR cybersecurity architect.

Any salary expectations I should be aware of?

Thanks

Anyone have a CFE designation and taken the test recently? Debating about getting it wasn’t sure if it’s worth it.

Hi everyone

Can someone please help me understand hierarchy at BNY Perishing. Where does a Grade J stands?

Anyone interview at Culture Amp and had to do a presentation?

Could anyone shed some light on the working environment at Arnold & Porter? I've been offered a role as a trainee lawyer but wanted to know if its a safe environment in the sense that I could ask for support if I ever needed it.

Many thanks in advance!

How do the titles/levels work at Meta within Business Planning & Operations (BP&O) / Meta Business Group (MBG)? i.e. Is a BP&O Lead above or below a BP&O Program Manager and what IC levels do they correspond to?

How's Amazon's WLB compared to consulting firms like Deloitte?

Is KGS gives wfh set up reimbursement to new joiners? Any new joiners out there

I recently joined a company after being self employed. I’m on hubs’s health insurance. We have no kids. It’s United healthcare. The company offers United as health insurance. What’s the best way to compare plans? I have not been in this situation before so apologies in advance if this is a dumb question.

Has anyone asked for a refund for payments made towards student loans during the pandemic and actually received it yet?

Anyone here over 70% in VOO or VTI? Is that a smart move for less-involved investor?

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

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!

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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).

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

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)

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?

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

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?

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

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

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

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

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?