I went to google, YouTube and have had no luck. I’m trying to pull the text with the most occurrences to display in box automatically based on the raw data. The formula I’m using is =index(d2:d1048576,mode(match(d2:d1048576, d2:d1048576,0))) but the results keep coming back #n/a.

Anyone ready for NYC gathering?

Any of Dfw female fishes interested in spending time over drinks/ dinner chat abot life, fun friendly conversation, may we watch a movie together. ? Brown Male 36 .

Where do professionals 30+ meet people these days besides dating apps?!

Has anyone actually found love at work? My best friend started at a new company 6 months ago and she just took an offer somewhere else because she and her senior manager fell for each other. After 6 months she knew it was worth leaving her job for! I've been working at the same place for three years and I went on one date with a guy who didn't even work with me he just worked in the building. What am I doing wrong.

How much are you on, 8 years in audit (senior manager) in New York v San Fran? Base.

Compliance email might as well just say: We hope you are all in compliance with our very strict "You aren't allowed to have a good body" busy season restriction.

has anyone had any luck leveraging an offer from another Big 4 to have your current firm match/transfer the new offer? specifically switching service lines

When you are involved in an agile transformation for a client, do you prioritize advancing the agile maturity or driving the project to successful completion? Sometimes it feels like these things are mutually exclusive, or I need to wear multiple hats and go beyond “agile coach”.

Is at home service still as popular as it was during the pandemic?

Digital interview process ?

Question for yall. How likely is an offer once a company decides to do a reference check? I know I am in the final 2, from context clues in interviews. I just dont want to get my hopes up.

I am a UX designer who has completed a Google certification program along with a resume and professional portfolio. However, I’ve struggled to find a job (remote). Any advice or resources I could use? Or are there any employers currently hiring and are interested? I’d be happy to hear from you.

Hey, I am very much interested in working for Agoda. Are there any referral leads? I applied for a few roles but did not get get any response yet. Any leads would be highly appreciated :)

What is salary range for Senior Manager – Financial Systems based out of Bangkok? What are other benefits provided by Agoda Thailand?

Went through multi-day loop for L5 SA and felt confident in my interactions. Presentation went well with no lack of answers for follow up questions. Just found out 6 days later I will not be receiving an offer, and it is policy to not provide feedback of gaps or reasons behind no offer. Also found out they ask you not to reapply for 1 to 2 years for same role. Would anyone recommend an alternate path for feedback on interview (outside of recruiter) and is the 1-2 year policy true?

Anyone in here have a hospital job for a unit secretary position? How much does it pay in California? Any help is greatly appreciated

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

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?

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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!

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

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?

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

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

What are your top Excel ninja tricks? Ones that few people know...

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.

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?

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.

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?

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?

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)

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