Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Hi Guys, i got my offer letter today and my joinining was given as 13th July which is lessa than 1 month. I called up my recruiter, she mentioned that you can change ur DOJ anytime. Just wanted to know the process. If anyone can help.

I applied for few SA roles at AWS after getting the SAA certificate and some badges like the “WAF” and “Advanced Migration”. I also optimized my resume recently trying to match what AWS would look for, but I did not get any 1st call or screening interview!
I also applied to some of the roles using friend’s referral. I have more than 15 years in IT infrastructure mainly in Storage systems (EMC, Hitachi) What could be the problem? Thanks.

Recently received my CSW license and have started working as a therapist at an outpatient clinic. Is a starting salary of $64,500 fair? I am supposed to aim for 28 billing hours (get paid if clients show or not) a week with 12 hours of admin time for other tasks. Thanks for any input.

What are the expectations for 1.5 years experienced DevOps engineer in market.

Hi! I was wondering if anyone here works at @Patreon (doesn’t seem like I can tag it so maybe not)? Wanted to chat about what it’s like to work there, etc. PS: this post also doubles as a plea for likes so I can DM (please) Thanks in advance!

What's the max salary given to Test Automation engineer? With 3.5 years of total experience?

@infosys
@cognizant
@accenture
@Tcs
@wipro
@Deloitte
@capgemini
Or any other company

Hello, any referrals for test lead in CGI? I also have Canada PR

Anyone refer for java 6 years experience for ford? Lwd 22 aug

After 4 months of casually applying and 3 months of dedicated searching after work hours, 130+ applications, 5 recruiter screens and 3 final rounds later... finally found an exit!!! You can all do it - I believe in you all!

Hi Fishes,
Does anyone know about NBS CONEXTS in novartis? If so please share details about it and how good is joining CTS division.

I am looking to work for a bank or financial institution in the US with presence in Latin America, I know about Citi and JPM any other?

How does everyone feel about CCA / The Gong Show?

How many folks here looking to actually connect for serious relationship (potentially converting to marriage)?

I’ll start 🙋🏻‍♂️ 30, located in the US (east coast) - open to worldwide relocation.

Could someone who is in the room on talent day please explain the process? Our are names just put on a slide show with your snapshot scores, chargeability, firm wide contributions, and years of experience then MDs just give the green light or not? Any clarification would be greatly appreciated!

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!

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

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?

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

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

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

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

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?

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!

Would anyone be willing to teach me vlookup?

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

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?