Hi, trying to do what I think requires IF Function.
IF there are over 250 dogs & 150 cats level 1
IF there are over 500 dogs & 300 cats level 2
And so forth

The wrong levels are showing for the amount of dogs & cats to reach a level.

What am I doing wrong 😫
(formula to the right)

Who decides the Hike percentage in EY GDS ?

Please help me to understand if counsellor plays any role in hike percentage or is that based on Current rating we have got while VPB announcement ?

Hi , is there someone who can refer me for an open position?

I’m white.. and a man. Shhh, don’t tell anyone.

Let’s be honest, what % of the entering class from consulting to m7 schools do we think used an admissions consultant? I think it’s upwards of 40%

Locums-are you flying or driving to assignments? If flying, how are you dealing with flight changes?

People of God, in addition to strategic action, I think it’s best to pray for wisdom, leadership, and healing across the land. Please let me know if you would like prayer. It has been an emotionally taxing past few days for sure.

Over the last couple of months I’ve interviewed for a number of jobs and made it to second and third round interviews but never got an offer. My last interview was on Monday and I got feedback that I did not get selected because it did not seem like I was a a team player. Ive got three interviews coming up and l am wondering how I can improve my chances of getting an offer. Any ideas are welcome. I need a new job like yesterday.

Guys please suggest any good hotel(no need hifi, just for night stay) to stay in kharadi, Pune or near by.
I have 2 days working office in a week. Need for 2-3 days only.
If you have any idea please suggest.

My firm’s IT (especially system saving and file locating function) is so bad 😐😞 and they keep doing updates no one asked them for just to mess with the stuff we already got a hang of without doing anything about the issues we actually need fixed. Anyone else in a similar boat? Do you bill the client for the time it takes to fix the IT issue (or IT inefficiency generally, like time taken to find a file in a convoluted system)? Or is that supposed to be our non-billable time?

Extremely Disappointed with hikes!

I’m new to the country. This is a bit out there but where do you get an abortion? Do you need a referral through your GP? After that is there a long wait?

How long does it take to get ofc Laptop after DOJ?

Opinions about Phantom?

Anyone knows how much does a senior director corporate strategy at diagnostic company such as Siemens Healthineers make? (Base, Bonus and LTE for someone with over 12 yoe)

If anyone is looking for referrals at Servicetitan, hit me up.

A first year asked me today how to maintain wlb to make the job work long term. Oh you sweet summer child.

Hi all, is anyone hiring a senior or a lead recruiter, I have a really good reference

I have resigned from EY GDS on the e-exit portal a few days back. What are the next steps that I need to do.
Also, when will I get a mail to submit my assets and for any other formalities.

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.

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 keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Would anyone be willing to teach me vlookup?

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. 😂🤯

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?

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!

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!

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

How long did it take you to become good at excel? Like fast?

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

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.

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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?