Your favorite formula (or combination) that you get surprised someone didn’t know. E.g I like using SUMIFs and surprised people still use SUMIF. Also SUMPRODUCT another favorite one of mine.

I'm a noob when it comes to drinking alcohol.
Can you guys suggest some good whiskey or wine?
Budget - max 6000

So can somebody explain to me what will happen to my Tesla stocks after stock split. Apologies new in the game and trying to get my head around it ☺️

Anyone concerned about the alleged “stealth” layoffs? Wondering which firms are doing this…

I got offers from top consulting firms in Berlin and Amsterdam. Any ideas what factors to consider in my decision?

Hi Sharks,

Looking for Project Management, PMO role.
Current Role: Senior Consultant 2
YOE: 7+
Skills: Project Management, Product Management, Scrum Master, IT Audit, Regulatory Compliance, Dashboarding
Certification: PMP, CSM
Notice Period: 90 days

Looking for guidance and support for interviews and CV.
Thanks !

Anyone else have clients that request to run production costs through Octerra? It’s a new request from my clients procurement team and I’m hoping to hear some insider scoop. Thanks!

So I just had 2 tables fight in a restaurant. Table A coughed and table B said oh covid and laughed. Happens that table A is Asian and table B is white.
Table A assumed the joke is because they are Asian and table B says no, everyone got covid not just Asians it’s just a bad joke; who is right?
Table A escalated to a fight and had to be both separated and asked to leave. Who is right?

How do you handle RSU comp? Do you sell them as soon as they are in your account or keep a percentage... or leave as it is? First time in my career that I have rsus are part of my comp, so not sure what to do.

I am currently looking for Teamcenter admin job, let me know if there is any opportunity. I have 9 years of experience.

If you had to explain to executives the specialized critical skill set PMs have, as to why account managers shouldn’t absorb their duties, what 3-4 skills would you say?

In luxoft after receiving offer letter they asked for client interview.what will happen if I will not clear this? One of my friend has this query

Does anyone have feedback on working for Mercer Advisors? I see a few positions in the Rockwall/ Dallas area that intrigue me. I’ve read Glassdoor reviews- was looking for more in-depth info.
I have my SIE, Series 6 and Series 63.
What is the work culture like, PTO, management style? Thanks!

Hi, does anyone know what the base salary is for A2 audit in SF office is? Big4. Thanks!

What’re the best restaurants you’ve tried this month? Surprise to me my fav place I went to was Makan

Hello Everyone!

Can anyone refer me to Ritedose Corp. in Columbia, SC? In dire neeed of help of getting a job.

Anyone have experience with working with Amwell or using their service? What was your experience like?

How do you index match (or vlookup) on multiple columns when you have a few thousand rows? I have like 3 things criteria I want to match and doing this manually kinda sucks right now.

Anybody know if you can access an older version of an excel file (like from version history) using vba?

Trying to write a script to compare old versions and list changes since a given date

I’ve got some lookups to do but inconsistent unique identifiers (names with Bob G01 vs Bob G1). More experienced fish, what’s the best way to perform look ups with this kind of unclean data? Got a few

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

What are your favorite excel macros to make you more efficient at work?

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

Is there a way to import subscriber counts from YouTube channels and have the ability to refresh this data?

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

Is there a good tutorial out there to automate creating pivot tables and then creating a PowerPoint pres with those pivots? Trying to do with with macros and the syntax is really giving me a hard time.

Is Excel extremely slow at updating/calculating formulas for anyone else recently?

Tips for fixing index match when it’s working for most lookups but some are returning NA despite being in the list?

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)

I have a date I need to match to an array of strings (that represents dates). Eg matching 6 nov 20 to (20201106, 20201107, etc. ). I can convert my date into this format using text(date,”yyyymmdd”) but then my lookup tried to match “20201106” with that list and the “ causes a mismatch. Any hints, and I would prefer not to change the array format?

Just wanna say thank you to this group of beautiful people, always willing to help each other reach a solution!

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

This post is possibly in the wrong bowl, but I couldn't figure out where to post this. I'm getting inundated with requests from people randomly walking in the halls or stopping by my desk asking me for this report or just any other task. I'm looking for a way to keep better track of these things as asking people to send me an email on it as a reminder isn't working - they're not sending it - yet they manage to come back around to get a status update on their ask. Any tips on how to manage?

Trying to count the maximum number of overlaps in at a given time in a series of date ranges. Finding an overlap is easy, but not sure how to cycle through date ranges while keeping a Max count

Is there an easy way to convert a manipulated pivot table to a normal table but automatically retain all the subtotal formula and grouping? For example, I have a pivot table with 3row fields (country, region, customer) And a 1 column field by month. I want to make a presentation to show top 5 customer by country and region….and group rest as “all other”….thanks’!!🙏

Hey all, for VBA what would the code be for searching for a specific value in column A and once that value is found go to the next row, do a loop that basically copies and pasted that value into Column C, the next row would then be copied and pasted in column D, then next to E, F, and G then back to C…. Until another specific value is found?