If Excel granted you one wish—any feature, any magic button—what would it be? Mine: automatic, one-click data clean-up for messy imports.

like
Posting as :
works at
You are currently posting as works at

Instant money button. Every time I click it I get $10,000 deposited into my bank account

funnylike

Nice one haha

How would that even work? If you have a defined schema you could definitely ask gpt to write you a script or if you’re even less competent use power query

like

Just magical LOL

Pinpoint specific problems within my functions rather than giving me a standard ERROR or N/A along with a general message. Love using nested INDEX MATCH formulas for populating data between sheets, and they can get so long... takes me a little bit to get the formula right just because I've maybe missed a closing parenthesis or I incorrectly typed the name of a sheet.

like

Oh my yes!! Excel should definitely have better error notice

Track changes

that's a good one

One click change management :)

One click to show variances in formatting that makes half the formulas work half the time...or not.

Lol!

Related Posts

Any moms on here that absolutely love their company and feel 100% supported?

like

Counselor told me yesterday that the firm is considering cutting me due to low utilization. Any recommendations?

like

Anyone work in the Healthcare industry? I'm looking into joining Healthcare. I'm currently a Senior in tax compliance.

like

I put in a booking request for a vacation and it got rejected and says “DC Approval Required: Chargeable” what does this mean? Did I do something wrong?

like

Is there any fish who is willing to refer me to @stax

like

Is associate and junior the same? If not, what's the difference?

like

Hi fishes,

What is the average salary that a Manager - Business Analytics can expect in Gartner. YOE - 3.8 years

like

I’m 30. My friends’ weddings are piling up and I’m just... still very much single. Feel like it’s acceptable in NYC but also sorta depressing. Dating is hard.

like
like

Nothing like losing an entire day of studying because Kaplan was down all day yesterday. Make sure you download the QBank for offline use, seems like this keeps happening on Sunday for some reason.

like

After I eat sehri, I just want to lay down while my stomach looks like a mountain. Then I become so lazy to get up for fajr. Shaitan is locked up, it feels like I’m the shaitan, don’t wanna get up ...

funnylike

Hello all

Can someone please help me how to get an offer when we have 90 days notice period? As most of the consultancies are expecting only 30 days. I wanted to move out of tcs as I'm not much comfortable with the project and team.

Expecting a suggestion from you all.

like

Looking to get an Alfa Romeo Giulia Ti sometime this year. Brand new the MSRP is about 45K and despite the reputation of the old Alfa Romeo’s from the 90’s these seem to be night and day more reliable. Would you recommend buying new, leasing new, or buying used? If I bought used it would be anywhere from 2019-2021

like

I would like to transition into a Clinical Informaticist role here at DFW Region. What is the median salary for this specialty?
Research shows that the top is about 78K annually.
Is this data correct. Bedside nurses appears to earn more.

like

I'm looking to get into production accounting, specifically interested in becoming a production accountant for a media production company. Any tips or advice? Any companies I should look into/reach out to in Toronto?

like

Hi. I’ve directed a few social spots and a doc/branded content campaign for my agency. None of work was PRd, so no credits. Interested in directing long term. How have you seen creatives make switch?

like

Immediate opening in my company. Please message for details on how to send CV to me. Also, it would be great if you can share or like as you feel like. So that i can have access to your message in DM. Thanks


This opportunity is in Pune and Chennai

Post Photo
like

Hi all,

Can any one let me know What is the difference between designation Associate I and Associate II in JPMC ?

Which one is better and why?

like

What band does managing consultant belongs to and what is the pay range

like

Hi Fishes,

Citiustech healthcare technologies is hiring for multiple roles. Java,C#,.net,Angular . Training will be provided for senior software engineers under Java impact program with attractive bonuses.
DM me if interested..

like

Additional Posts in Excel Genius

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Still don't have xlookup. #fomo

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

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

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

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?

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
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

General

Legal