What’s the most complex formula or function you’ve ever created in Excel?

First year staff and I think this job is making my depression come back. I find no meaning whatsoever in what I do and just want to cry every morning thinking of going to work.

Anybody work at/for Bristol Myers Squibb? Do they get to wear jeans?

Can a sex less marriage survive if everything else is as great as a couple can have in realistic and non filmy scenario.

Has anyone had any lucky finding a vaccine appt?

Hello Guys,
Need small advice,
I had my LWD on 27th june ,before a week of that i had HSbC last round in which I clearly told I wanted to join by 4th july as my next joining is due at that time.
HR agreed and told will fast track your bgv .
Now the problem is they released offer for 11thJuly saying will preponed in case bgv finished early.
Today I again got a mail for 18th july extension.

Am quite worried here now, as I already said no to other companies !should I try looking again.

How job security in Persistent system?
What is the bench period? .Are projects generally short term or long term.?

For those that have worked at a Bulge Bracket and an Elite Boutique, I’d love to hear you compare/contrast your experiences.

Dell emc provide welcome kit?

Hi fellow Fishes,
I came across an interesting opportunity at Tavisca.
Can anyone refer me for the position?
Thanks in advance!

Can anyone please refer me, have 2 years experience in Java, SQL, Spring Boot, Hibernate and Microservices.
Current company - Cognizant
LWD - 20th October

Thanks,

FAANG is now MAMAA (Meta, Apple, Microsoft, Amazon and Alphabet)…Whoa Mama! As if there weren’t enough acronyms in our lives. Happy Friday All!!!

Hi fishes

YOE 2.11
ROLE:- DEVOPS
COMPANY ACCENTURE SOLUTIONS PVT LTD
PROJECT :- Manage My Price

I will join Accenture on 10th Dec and i have been assigned to this project in Accenture.

Does anyone have any clue about the project and what can i accept from it.
Im looking for future onsite opportunity, growth in term of technology.
Is it there in this project

Please help 😃

What is reasonable to ask in a potential new job if you’re currently earning $50K. Is $15K too much? What’s a good range?

Joining Accenture Strategy in the Fall – any notable benefits I should be aware of?

Hello Fishes,

I urgently need a suggestion, yesterday I have joined a company, but I haven't submitted all the documents yet.
I'm yet to complete the on boarding process.
Can I abscond them today i.e. after 1 day?
If yes, what reason I should tell them?

Yesterday night, I have got a better opportunity.

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!

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)

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

How do you fix microsoft excel cannot paste data error?

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

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?

Still don't have xlookup. #fomo

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?

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?

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

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!

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

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

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?

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