{ "_id": "5a56f68d15f6ef0013aad256", "name": "Excel Genius", "type": 2, "creatorId": "5a328e7245ae9f00180fa77e", "bowlType": "58e6c2e40ebdd20010849126", "bowlTypeName": "Professional Expertise", "isVisible": true, "isPublic": true, "divisions": [], "feedState": { "lastMessage": "I’m on a Mac and trying to do 2 things: Merge a bunch of P&L quick books sheets into one excel file, and then consolidate them into one table. Any suggestions?", "lastSign": "Strategy&", "lastUpdateDate": "2021-09-17T01:27:26.471Z", "lastMessageDate": "2021-09-17T01:27:26.471Z", "countOfSystemMessages": 0, "countOfUserMessages": 998, "countOfMessages": 998 }, "numberOfUsers": 29413, "relatedCrowdIds": [ "552d1d24dc1c586b09d2d051", "564a5cdb94887803001dd07c", "552d1d24dc1c586b09d2d052", "553769a790f5eebe1d2a0f92", "5565cfca8b2b9a03009acf57", "5eb1bcb23b975f0021424ca1", "55375ce690f5eebe1d2a0f88", "5682e6afd55b9e0f00fce669", "5787dd60a3f35c130082b851", "56c75c3c1dc12b0a0097ccb0", "56fd40e29238700e00b5ee4a", "5d0a757f66884500200aff25", "564cbaf767469503004fede0", "5e4bca4d473da1001b53cb24" ], "background": { "from": "05B3DF", "to": "0F71A6" }, "creationDate": "2018-01-11T05:30:53.591Z", "priority": 0, "isLocked": false, "description": "Discussions, Useful Tips, Resources, Macros, More", "numberOfNetworkingUsers": 319, "iconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/zyKRUmCcr4SD4.png", "handleUrl": "excel-genius", "fishIconColor": "4c28ff", "numberOfFollowers": 11891, "categories": [], "promptsDisabled": true, "roomEnabled": true, "suggestedIndustry": { "_id": "552d1d24dc1c586b09d2d051", "name": "Consulting", "iconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/q6ousBABT88sI.png", "crowdIconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/KF6SyAmqgD6Ae.png" }, "lastView": "Invalid date" }
Discussions, Useful Tips, Resources, Macros, More
Sign up to access more conversations in this bowl 🔑

I’m on a Mac and trying to do 2 things: Merge a bunch of P&L quick books sheets into one excel file, and then consolidate them into one table. Any suggestions?

like

I’ve got a pivot table set up of payments made throughout the year. How do I get the day that the most payments were made on ?

like

Excel gurus I need help ASAP! Is there a way to convert a process flow into a checklist in excel? The main confusion I’m having is how to take the diamonds of the process flow and based on the respons… more

like

Can anybody tell me how one can open a list off all tabs to navigate in a workbook with many tabs?

like

Anyone know a quick way to value paste for each tab to another excel file if I have 40 tabs in a file needed to copy. Each tab has many formula in there, but when copy-over I only want them to show ha… more

like
like

Hello! I am exhausted of googling how to create an excel file to add expanders within a cell and all I can find is how to group and hide. Which this is not what I am referring. I saw a file in which you can do this in excel but I can’t seem to find it. It looks something like the below picture. This is a plus sign in which you can expand and collapse. I appreciate your help

Post Photo
like

Anyone ever dealt with grouped rows / columns inexplicably stopping working? I have a big and pretty important model which uses grouped rows a lot (to click the plus and pop out more detail), and yest… more

like

Is there a way to copy filtered data (hidden rows) and paste it into an entirely different worksheet that is also filtered?

like

Anyone run into an instance where one VBA goal seek will work within a loop and then another vba goal seek not in a loop within the same workbook won’t work? I’ve done some google research and it seem… more

like

Not sure where this post belongs because I don’t think it’s an excel solution, but I want to be able to pull data from various direct datafeeds (and be able to pull in reports from say excel as well).… more

like

Is there any way to generate a summary of comments or view all comment for a workbook?

like

Is there a factset formula to pull price and EV and EBITDA for a company at the date of IPO? Not sure if Factset is that sophisticated… I also suck with factset

like

How do you convert quarterly data to annual data (assume annual = average of 4 quarterly data points)? Data is in this format: C2: 2020-03 D2: 2020-06 E2: 2020-09 F2: 2020-12 G2: 2021-03 … I am able … more

like

I have a COUNTIF and want to single out data greater than 5 and less than 100. How do I include both within the formula?

like

Does anyone know how to make it so that a scatter plot doesn’t shrink when you filter on a table? Because the cells disappear with the filter, the scatter plot then goes to about half the size? Also h… more

like

Using Vlookup to pull corresponding service and corresponding region to these customer codes. Took codes from column D straight from the source file I’m looking in, so no way there are any typs or format issues. Any idea why some cells are pulling N/A?

Post Photo
like

Hi geniuses, question about updating data validation drop-downs. If I rename a value in a cell’s source list from “test” to “testing”, it does not automatically update the cell if I’ve already selecte… more

like

I run an NFL survivor pool each year. Is there any way I could create a sheet where people could only edit picks each week next to their name (not able to change other people's picks) and it could… more

like

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

like
Share this 🔥 post

Alright geniuses, I am stumped. I'm trying to calculate growth in rental income and want to compare only for properties that existed across the whole time frame. Since 12mths ago, new properties have been added to the portfolio and so rent is higher, but %growth should not include new properties that have come on. To illustrate, % growth from month1 to month6 should only include the properties in dark green in the numerator and not the rest of the properties showing income in month 6.

Post Photo
like

Building LBOs and my circularities keep breaking everytime I refresh or save the model. If I turn the circuit switch off and on then everything works again but it makes analysis really hard to run. An… more

like

Hi Geniuses. I’m needing to write some compounded if statements and use VSlookup to analyze, group and report based on data in a dataset. Anyone have a decent learning source? Google and YouTube have … more

like

What are the most annoying things for you in old-school excel users? I’ll start: 1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like
Share this 🔥 post

What’s the cheapest way to download Microsoft excel? I don’t have a student email

likehelpful

How do you highlight two separate areas (you can do it with control shift) using only the keyboard? I heard you can do it with a F number key.

like

Has anyone had any success here with recording a macro to set up a pivot table? For context, I am just looking to run a pivot and then run the macro and have it show the pivot table completed with the… more

like

Anyone have a good source to learn sql

like

Can anyone recommend free or paid excel resources that are more general in nature? I need to up my skills but not in one specific area. Thanks!

likehelpful
Share this 🔥 post

Any good suggestions for SLA tracking in Excel?

like

What is a multibyte character and how can I identify and remove them from my excel file?

like

Does anyone know why I am getting a VALUE error when everyone else on my team can open the sheet and not have that error? Is it something in my excel settings?

like

Any advice on how to enhance excel skills In index match functions and sum ifs ?

like

Hello guys, I have some@ excel tables which I would like to include in a pptx slides in a way that I kam keep a nice formatting for presentation and hard copy and also make amendments in the slides d… more

like

How to work with ranges in IF ELSE formula in VBA? I found for loops but they are erroring. Any help would be appreciated. If you could help me print a range, that would be helpful to understand and … more

like

So, I’m interviewing for a job that is looking for someone with VBA. I have no idea what VBA is and how fast can I learn it? Tools, tips are appreciated!!

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

What’s your favorite way to do a notes tab? I was using [00] to number them and then using hyperlinks but they break if I want to move the note around. I’d like a way to navigate to and from.

like

I have 3 status columns. Each column has 3 status options (open, in process and closed). We want a final status column to display the lesser of all three columns. Example: columns A-B are Closed and c… more

like

I am looking to create a file migration calendar in Excel that will show four types of information: the name of the person doing the transfer, where the file is located, the group to which the file be… more

like
Download Fishbowl to see what others are saying
That was just a preview…
Sign Up to see all discussions
  • Discover what 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 other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the Fishbowl app

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal