Me: Simple math. Excel: Let's go back in time to when no one asked for this.

Post Photo
funnylike
Posting as :
works at
You are currently posting as works at

It is just one of those things that adds character to it! Honestly though once I really got comfortable using Excel I don’t have as many oddball problems anymore. Not to say never, sometimes it really does like to still make some creative choices when using it. Ctrl Z is my best friend in it.

like

This kind of thing drives me insane!! I cannot tell you how many times I have had it out with Excel because it starts doing things like this and I am like no no, I didn't want that as a date. If I wanted that as a date I would have typed it that way!

Related Posts

I was brought on a project to assist procurement and ap with their transition to new erp. However, I see many issues that get brought up to me in meetings around more strategy based work or process changes that are not in scope for my project. How would you go about trying to help in these areas without stepping on toes or interfering with other internal stakeholders. Part of me feels like the new erp system is causing more issues and you can make a bigger difference through people/process Chang

like

It looks Verizon India is following Hybrid work model in 2022

Any idea about what would be the work model in 2023 HYBRID or WFO ?

like

Any Nigerian consultants based in Nigeria?

like

Any 🐠 out and about tonight in town ? Would be keen to grab a drink with fellow 🐟 if anyone is interested. Based out of midtown

Fish friends. I live in Kansas but am starting a new remote job working with a company North Carolina. Are there any tax experts out there who know how to not get screwed by how I manage my taxes with this new job?

like

I am a deputy manager with 8 years of experience in retail banking operations CTC is 5.64L, now HSBC global services is offering 70% hike, however, the grade will be assistant manager. Should I accept the offer? Would degrading the designation from deputy manager to assistant manager be a mistake? Please suggest.

I have a coworker who’s a functional alcoholic. I’ve never dealt with a situation like this before so I don’t even know if it’s my place to say something

like

Can anyone invest in Roth IRA asking with 401k or is there a limit based on salary? I was told if you are making above X, you can't invest in Roth IRA. If this is true what's is X amount?

like

Thoughts on the new Chase Freedom Flex?

like

Anyone doing any crypto credit cards? I still think BofA platinum honors is the best since it’s the most cash back that can then be converted. Anyone have any other clever ways to earn lots of crypto passively (lolli, DeFi, mining, etc)?

like

Anyone working at Abbie willing to provide reference? Desperately need one

like

Hi,
Citi is calling me to office
It will be hybrid model
So i am looking for a flat
Which society and area is best for living in nearby office with good amenities within a 1-2km range of distance from office.

Which society has best PG/flat at affordable cost

like

Hi-Any idea which lines within EY are struggling?

like

How do I get better at product strategy? Specifically for google PM onsite questions

like

McKinsey consultants- I remember hearing that you have a different comp model from most firms (where title and pay aren't necessarily linked). Does anyone mind elaborating?

like

At what time do we receive the KPMG (KGS)
salary and salary slip?

like

Hi dear ones,
Kindly let me know if there are any job openings with good salary package, in data science field for someone with 1 YoE as an intern. If anyone could refer, it would be much appreciated. Thanks in advance 😊

like

What is a good salary for a director in NY?

like

DM for referrals in Oracle.
Experience: 4+ Years
Vacancies available for:
Java/Microservices Developer, SpringBoot
Tableau Developer
Javascript/Apex/PL-SQL
SHAELL/Python Developer
Full Stack - Java/Python

Locations: Bangalore, Hyderrabad, Pune

like

Additional Posts in Excel Genius

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

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

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.

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

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

likehelpful

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

How do I compare two sheets to make sure they are identical?

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

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

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!

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

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

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

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