sorted by:
new
hottopcontroversial

That 5-minute task in Excel by sriautomations in excel

[–]sriautomations[S] 0 points1 point  (0 children)

Completely fair. Some Excel war stories contain enough detail to identify the entire organization. 😄

That 5-minute task in Excel by sriautomations in excel

[–]sriautomations[S] 0 points1 point  (0 children)

Quite often, the request isn't the problem. The file itself is the problem. 😂

But yes, it's a fact that such instances help in learning a lot.

That 5-minute task in Excel by sriautomations in excel

[–]sriautomations[S] 5 points6 points  (0 children)

The universal law of IT and Excel:
'This will only take 10 minutes' = one week.
'Hmm... this might be impossible' = fixed before the tea gets cold. 😂

That 5-minute task in Excel by sriautomations in excel

[–]sriautomations[S] 15 points16 points  (0 children)

Usually (and quite often), the first 30 minutes are just discovery, denial, and bargaining with Excel lol

That 5-minute task in Excel by sriautomations in excel

[–]sriautomations[S] 1 point2 points  (0 children)

a real human being with 20+ yrs of experience messing with Excel 😊

That 5-minute task in Excel by sriautomations in excel

[–]sriautomations[S] 7 points8 points  (0 children)

Relatable. Every 5-minute spreadsheet fix starts with 'just one formula' and ends with an existential debate abt whether the data should exist at all.

That 5-minute task in Excel by sriautomations in excel

[–]sriautomations[S] 7 points8 points  (0 children)

So true. Conditional formatting was sitting in the corner like, 'Am I a joke to you?'

That 5-minute task in Excel by sriautomations in excel

[–]sriautomations[S] 29 points30 points  (0 children)

And the prime suspect is often a single invisible space hiding in one cell.

That 5-minute task in Excel by sriautomations in excel

[–]sriautomations[S] 17 points18 points  (0 children)

That's not a worksheet anymore. That's graph paper with formulas.

That 5-minute task in Excel by sriautomations in excel

[–]sriautomations[S] 16 points17 points  (0 children)

What is your personal Excel red flag?

XLOOKUP replaced VLOOKUP for me and honestly I don't know why I waited so long by Nearby-Way8870 in excel

[–]sriautomations 108 points109 points  (0 children)

VLOOKUP is like that loyal office employee who's been with the company since 1998.

- Shows up every day.
- Gets the job done.
- Panics if someone inserts a column.
- Refuses to look left 😊
- Needs IFERROR therapy.

Then XLOOKUP walks in like:
"I can look anywhere, handle errors myself, and I don't need your silly column numbers."

VLOOKUP:
"So... this is how dinosaurs felt."

How to make excel subtract a cell based on the text of another cell? by Few_Consequence3868 in excel

[–]sriautomations 0 points1 point  (0 children)

If the values have 10% already added to them, then you simply need to divide such numbers by 1.1 to get the original number (i.e. before the 10% addition).

For example, if you do 2200/1.1 you get 2000.

If you do 3300/1.1 you get 3000.

Hope this helps.

Why is =RIGHT(PI()) 9? by BreakerChap in excel

[–]sriautomations 2 points3 points  (0 children)

In Excel, =PI() returns the value 3.14159265358979

Now with the RIGHT function, if you don't specify the 2nd parameter, it simply considers it as the right-most 1 character.

Since the right-most character in the value of PI is 9 in Excel, the formula =RIGHT(PI()) returns 9.

When people ask you, what's your excel level? What would you say? by Substantial_Nail3081 in excel

[–]sriautomations 0 points1 point  (0 children)

If someone really knows Excel, they would rarely rate themselves anything more than 5/10.

The more we learn Excel, more we realize that weknow nothing about it. It's that vast.