Companies
Bowls
Topics
Posts
Blog
Posting as :
an Assistant Vice President
▸ Excel Genius
You are currently posting as works at Assistant Vice President

If I have NAME, REF etc errors in different spots of a very large worksheet, is there a quick way to delete all formulas that are bringing errors?

like
Posting as :
works at
You are currently posting as works at
Posting as :
a Tax Associate 1
You are currently posting as Tax Associate 1Badge Image

You can use control + F and go to options and make sure you’re searching in formulas and type in NAME or REF. This should bring up all the formulas that you’re looking for. You can then replace all those formulas with 0 or whatever you want. Not sure if this helps…

Post Photo
like
Posting as :
Dave Clark
You are currently posting as Dave ClarkBadge Image

You could select the entire sheet and use conditional formatting to locate every cell with that error.

Related Posts

Posting as :
works at PwC
▸ advisory
You are currently posting as works at PwC

H-1B dropbox under "Administrative processing" in Mumbai consulate. Has anyone experienced admin processing recently? What was the processing time? I'm not getting a good feeling about this one

like
Posting as :
a Consultant
▸ strategy
You are currently posting as works at Consultant

Indians in Chicago willing to catch up? We can meet in an outdoor setting if that works!

like
Posting as :
works at Novartis
▸ Strategy
You are currently posting as works at Novartis

What’s the minimum experience needed for manager role Genpact ? Also, what’s the pay bracket for 4B and 4C band?

like
Posting as :
a Consultant
▸ Technology
You are currently posting as works at Consultant

Hope I can use him as a pillow

Post Photo
likefunny
Posting as :
a Marketing Director
▸ Federal
You are currently posting as works at Marketing Director

Anyone worried about leaving your current company and the economy sinking and getting laid off?

like
Posting as :
an Analyst
▸ Engineering
You are currently posting as works at AnalystBadge Image

Anyone gave interview for manual test in IHS Markit IHS Markit

Please help with the interview questions IHS Markit IHS Markit

Posting as :
a Senior Manager
▸ Analytics
You are currently posting as works at Senior ManagerBadge Image

Dallas winos: I have an ‘08 Silver Oak I’d love to trade for anything Old World of similar value. It’s just not my thing

like
Posting as :
a Talent Acquisition Manager
You are currently posting as works at Talent Acquisition Manager

We're doing a wine only wedding (obvi this includes champagne) - what are your top picks to have available?

like
Posting as :
works at Wipro
▸ Engineering
You are currently posting as works at Wipro

Joined wipro 3 months back, CCTC is 13LPA, YOE:3.6, got one offer from Hashedin 16.3LPA.
Any suggestions?

Shall I negotiate Hashedin to increase the CTC?

like
Posting as :
works at CDK Global
▸ Sales
You are currently posting as works at CDK GlobalBadge Image

Is it a good time to switch jobs

like
Posting as :
a Consultant
▸ Strategy
You are currently posting as works at Consultant

Can I remain in the US and work for the Canadian branch of my company while my green card application is pending (my STEM OPT just expired and I haven’t gotten my green card approval yet). Traveling will mean abandoning my green card application 😩

like
Posting as :
works at EY
▸ Assurance
You are currently posting as works at EY

Any accounting folks on a visa exited to roles that aren’t audit/tax? Looking for ideas before I go back in debt to school lol

like
Posting as :
works at PwC
▸ Advisory
You are currently posting as works at PwC

Has anyone recently received a H1B visa stamp (renewal)?

like
Posting as :
a Digital Analytics Manager
▸ analytics
You are currently posting as works at Digital Analytics Manager

Best technical skills and learning opportunities for corporate finance?

- VBA, SQL, Python (Coursera/LinkedIn Learning)
- Quant (R)
- Hyperion or other apps (work)
- CFA study (books)

like
Posting as :
an Associate
▸ Law
You are currently posting as works at AssociateBadge Image

Visual Storyteller

To Do
+ send emails
+ call about case
+ draft thing
+ enter time
+ cry

Post Photo
likefunny
Posting as :
a Creative Design Lead
▸ creative
You are currently posting as works at Creative Design Lead

In the U.S. where we are approaching 5M cases, 165K deaths, we are also having a 10 day rally with 250K people who are openly flaunting not wearing masks.

like
Posting as :
a Director
▸ media
You are currently posting as works at Director

OH MY GOD who did that “shout it from the rooftops" Sprint robot commercial? IT’S INSANE(ly bad).

Posting as :
works at EY
▸ assurance
You are currently posting as works at EY

Got an interview at Deloitte tomorrow. Just a phone interview but I want this role. It's tech advisory. Any tips?

Posting as :
works at Infosys
▸ Human Capital & HR Consulting
You are currently posting as works at InfosysBadge Image

Is wfh still available in lti?

like
Posting as :
an Engineer
▸ Engineering
You are currently posting as works at EngineerBadge Image

What should be the average cost for renting a furnished single bhk near jp Morgan Bangalore?

like

Additional Posts in Excel Genius

Posting as :
an Associate
▸ Financial Services
You are currently posting as works at Associate

Is there a way to add trend lines/fitted lines for each category on a bar chart? Looking for something similar to below.

Post Photo
like
Posting as :
works at PwC
▸ assurance
You are currently posting as works at PwC

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting
Posting as :
works at FedEx
▸ Other (non-Software)
You are currently posting as works at FedExBadge Image

Anyone hit a manual on how to do EVERYTHING in excel 😭? PDF or something

like
Posting as :
works at CliftonLarsonAllen
▸ tax
You are currently posting as works at CliftonLarsonAllen

Our group is exploring Alteryx. When I review im Excel, I can click on a cell to verify the formula. In Alteryx, I will get a hard coded Excel sheet. What are some ideas to make Alteryx reviewable?

like
Posting as :
a Consultant
▸ Technology
You are currently posting as works at Consultant

I have been given a csv file and one of the columns has multiple properties. I want to split each of the properties into their own column. However every row doesn’t always have them in the same order and may have slightly different properties. Is there a way to sort this efficiently?- picture for reference, columns v onwards is how I have split with text to columns currently. Any help is greatly appreciated

Post Photo
like
Posting as :
works at KPMG
▸ Advisory
You are currently posting as works at KPMGBadge Image

Is there a way to add 3+ criterias into a vlookup and if there are multiple results, to list them in different cells?

like
Posting as :
works at IQVIA
▸ Financial Services
You are currently posting as works at IQVIA

What's the equivalent to a sumifs formula but instead of #s I want to bring in names. For example, i want to return a client name but only if it meets two criteria.

like
Posting as :
works at KPMG
▸ Tax
You are currently posting as works at KPMG

To see a list of all tabs you right click on the arrows to the left of the tabs. Is there a shortcut to this without a mouse?

like
Posting as :
works at EY
▸ strategy
You are currently posting as works at EY

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like
Posting as :
works at McKinsey & Company
▸ Strategy
You are currently posting as works at McKinsey & Company

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

likefunny
Posting as :
a Manager
▸ Strategy
You are currently posting as works at Manager

Time to convert to xlookup

Post Photo
likefunny
Posting as :
a Senior Consultant
▸ Technology
You are currently posting as works at Senior Consultant

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
Posting as :
a Specialist
▸ Other (non-Software)
You are currently posting as works at SpecialistBadge Image

Anyone know of any roles or companies that hire you with basic excel skills and train you in advanced excel/analytics?

likehelpful
Posting as :
works at KPMG
▸ analytics
You are currently posting as works at KPMG

What is one excel command that is faster if you use a mouse?

likefunny
Posting as :
a Healthcare Analyst
▸ Strategy
You are currently posting as works at Healthcare Analyst

Feeling behind at work. I’m relatively new to data/financial modeling. Any advice on learning how to take a client data set, cleaning it up, and turning it into a model for analysis? I’m a new consultant at a boutique and I’ve basically received no training at my company on how to use Excel to do this. Additionally, is this fair game for a new analyst to understand how to do this without any prior training?

like
Posting as :
a Practice Manager
▸ Administrator
You are currently posting as works at Practice Manager

Need to create an P&L for a physical therapy center without using existing excel templates. Just cap payment info, lease price, team member salaries and supply costs.

Seeking formula support…,and open to other tips and tricks.

Posting as :
a Supply Planner
▸ Other (non-Software)
You are currently posting as works at Supply Planner

Hello Excel champs , need your help with the below screenshot. First table contains the master data with Parent and Child item details. Agenda - is it find out all the child items pertaining to make 1 unit of the corresponding parent item. In this example I took Parent Item A and exploded all the Child items and the required units to make 1 unit. Now the challenge is that I have a master data of 250,000 line items and I am trying to figure out the exploded version of all the Parent items.

Post Photo
likesmart
Posting as :
works at Deloitte
▸ strategy
You are currently posting as works at Deloitte

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

like
Posting as :
an Associate Consultant
▸ Strategy
You are currently posting as works at Associate Consultant

Does anyone use XLOOKUP over Index Match? Why /why not?

like
Posting as :
an Intern
▸ Strategy
You are currently posting as works at Intern

I made a spreadsheet to track my dating success:

The spreadsheet has an input tab with qualitative and quantitative data as well as a dashboard that automatically updates 🙂

Post Photo
likefunnyhelpfulsmart

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.

Trending Topics

Assurance Senior Salary discussions
Chevron icon
Airports: BOS discussions
Chevron icon
Tax Associate Layoffs discussions
Chevron icon
Program Manager Interview discussions
Chevron icon
Strategist Benefits discussions
Chevron icon
Certifications - CSA discussions
Chevron icon
Consulting Senior Consultant Interview discussions
Chevron icon
Financial Analyst Jobs discussions
Chevron icon
Audit Assistant Jobs discussions
Chevron icon
Strategy Manager Layoffs discussions
Chevron icon
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

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

AppStore icon
App Store
Android icon
Google Play

General

Legal