Excel Genius

23111 members
Discussions, Useful Tips, Resources, Macros, More

I have a potentially dumb question: might be more math related than excel, but is there a formula to use to know whether something is more linear growth vs cyclical. So like if I have a lot of data po… more

like
Reaction Icon Like
Arrow Icon

Vlookup is a crutch that makes you bad at excel. Prove me wrong.

like
Reaction Icon Like
Arrow Icon

Help!! Time-sensitive: Please tell me how I can achieve this: To create concatenation of every possible combination of Type to Price for every ID. I provided an example below with the outcome I want in the second table. Would prefer if this be down without a macro.

Post Photo
like
Reaction Icon Like
Arrow Icon

Hi all, I bought access to Wall Street Prep’s modeling courses to enhance my modeling skills. I find that the material is a few years old and the guy in the video explaining everything is super monoto… more

like
Reaction Icon Like
Arrow Icon

What are some of the things you know or think python can potentially automate in your job?

like
Reaction Icon Like
Arrow Icon

Does anybody know what the +0 function does in a vlookup? I can send a formula for a better explanation if that would help. When I don’t include it, I get error returns from the lookup list...but with… more

like
Reaction Icon Like
Arrow Icon

Trying to set up a lookup where it returns a value based on two conditions, but conditions located in two different columns.

like
Reaction Icon Like
Arrow Icon

Friendly reminder as we are in QE. If you are dealing with large data sets which causes your computer to lag, use the virtual machine provided by your company to process and complete. VMs server proc… more

like
Reaction Icon Like
Arrow Icon

I’m trying to return a subset of two sheets. There is a list of names by week on one and a list of work assignments on the other. I want to filter out anyone who hasn’t done any of the assignments, bu… more

like
Reaction Icon Like
Arrow Icon

Any power query users here? Curious to know whether anyone has been able to use it in management consulting.

like
Reaction Icon Like
Arrow Icon

Anyone who has uses MX keys and MX mouse. What shortcuts do you use. Any other tips or tricks you would recommend.

like
Reaction Icon Like
Arrow Icon

Let’s say I’m looking at cost items and deciding if they should be COGS or Opex. I want to show the total for COGS and Opex, but also want to show the list of costs that roll up. I want to show the de… more

like
Reaction Icon Like
Arrow Icon

How do I calculate the number of non blank cells in column B associated with a unique number in column A? Trying to claim “x many non blank observations for LOANS from y many unique INVESTORS” (but for a much larger dataset)

Post Photo
like
Reaction Icon Like
Arrow Icon
like
Reaction Icon Like
Arrow Icon

Alright, Tip of the Week threads are cool but gonna remix this week. AMA (preferably Excel-related, but doesn’t have to be if you’re feeling particularly ~zany~). Will be back with our regularly sched… more

like
Reaction Icon Like
Arrow Icon

Why does my SUMIF formula not work if the data I am pulling from is filtered?

like
Reaction Icon Like
Arrow Icon

Why is it so f’ing hard to create or edit a bubble chart in excel.

like
Reaction Icon Like
Arrow Icon

Hey Fish! Trying to automate visualizations from microsoft forms to the final charts. I've used a power automate [aka flow] template to store each response as a record in a table, and the fields a… more

like
Reaction Icon Like
Arrow Icon

Is there a formula I can use to look for a value not equal to null, and spit out that value?

Post Photo
like
Reaction Icon Like
Arrow Icon

Download the Fishbowl app

That was just a preview…
Sign Up to see all discussions
  • Discover what’s it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Sign in here

Share

Embed this post

Copy and paste embed code on your site

Preview