I am trying to create a formula that will look at an employees Total Direct Comp $’s against the market 50-75th %ile numbers and if it is 5-10% greater than than the 50th %ile of the market it would deliver a label in the field = P50-P75. If the total TDC is less than the 50th %ile of the market number by 5-10% it would deliver a label in the field = P25-P50.

Thank you

What’s the best way to meet other DL gay dudes who are not into the boystown scene?

BCG or McKinsey for consumer goods/retail?

I found out that I can make more money starting, buying and running businesses than I can in law. Plus I'm home at 6pm every night. Did anyone find that out?

Switching from PDM 2 to SpM, should I expect a pay adjustment?

I've gotten the Deloitte D launch orientation survey. Me start date is on the 16th (less than 2 weeks). I've emailed BI onboarding twice, called my recruiter asking if they are ok with background/employment verification check and I've not gotten a response. I need to put in my 2 week notice and all my recuiter has said is I can push your start date out. Has anyone been thru this ? Does getting the D launch orientation email imply everything is good with background/employment checks

Thoughts on uneven bridal parties? I would have 5 vs my fiancé having 3 people.

Hey All,

Can anyone help me with a referral for Sales?

5+ YOE in Enterprise Sales(SaaS)

Thanks! 😊

Has anyone here moved from GDS to onshore teams, eg EY US, Canada etc? What is the process like? Do we need partner/counselor approvals?

If I resign from GDS and join EY US for example, will that create any issue?

Any assurance AM's here ? What is the salary range ? Qualified CA

Hey fishes,
Are certifications important for hikes while switching companies?

My mom is convinced that I'm eligible for the vaccine in NY because I work there, even though I live in NJ. Having trouble finding information to confirm this, aside from the CVS website where as part of the eligibility check, it asks "do you live or work in NY"?Can anyone confirm if this is true?

In house insurance defense comp. What’s the highest paid and lowest paid companies? Which companies give bonuses? Please provide yoe and salary.

Anyone here moved from EY to Accenture? Curious to know how was the shift, pros and cons for each company, any regrets? Waiting for an offer from Accenture but very conflicted on whether I should leave EY. Been there all my career and going to be a big jump.

Does sopra has hire and fire policy . (My client interview is not done . They have released the offer without second round )

3/29 Thread (General):

Has anyone left a wire house to go completely hourly fee based, and run your own financial consulting business? Is this a stupid idea or is it feasible?

Hi Fellow Testers(Automation, Manual, SDET)

Please post your current package, yoe, and tech/tool that you use, company if its okay. Want to see where does this career path lead to and different techs.

Does anyone have a recommendation for a good OB in NYC?

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

Would anyone be willing to teach me vlookup?

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

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?

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?

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.

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)

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.

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

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!

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.

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

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

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 anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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

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 🙏