pet peeves

Generally what bugs me most boils done to a lack of consideration for others. Cyclists running red lights, not queueing at bus stops, failure to say please or thank you...

Excel wise, limit on nested IFs. Automatically putting a space in my defined names, then returning an error value...
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
- Chav's who play cr@p music on the phone speakers
- Chav's in general to be honest
- Vegetarians who expect me to prepare a veggie meal for them but don't put a nice steak out for me when I go round
- Vegetarians in general to be honest
- Warm lager
- People who walk slowly while blocking the entire pavement
- Flat lager
- Monday mornings
- Warm flat lager
- Tuesday mornings
- Bar staff that ignore you
- Wednesday mornings
- Cr@p wine
- Thursday mornings
- Call centres (especially when they're abroad)
- Friday mornings
- The battery life on my new phone
- Sunday drivers (or any day when I want to get somewhere)
- SAP
- People who moan all the time
- Not having fun

If I think of anything else I'll let you know.

Dom
 
• Cyclists who insist on having those bl$%dy flashing lights on their bikes despite it being completely illegal.
• Police who drive past cyclists with flashing lights and don’t do a **** thing about it.
• Drivers who try to overtake me on my bike when there’s clearly no space (I’m a considerate cyclist and will let you pass when it’s suitable and safe)
 
Excel wise, limit on nested IFs. Automatically putting a space in my defined names, then returning an error value...

Can't think of a reason you would need, really, more than 3 or 4. If you need more than that then there most likely a much better way to do it...and usually, but not always, what you really need is a VLOOKUP. ;)
 
For the most part, I'm with Dom.
- Warm lager
- People who walk slowly while blocking the entire pavement
- Flat lager
- Monday mornings
- Warm flat lager
- Tuesday mornings
- Bar staff that ignore you
- Wednesday mornings
- Cr@p wine
- Thursday mornings
- Call centres (especially when they're abroad)
- Friday mornings
- The battery life on my new phone
- Sunday drivers (or any day when I want to get somewhere)
- People who moan all the time
- Not having fun
and want to include the following:
-when the guy that I share an office with digs at his ear with his keys! DISGUSTING!!!
-until recently - not being able to scroll in the VB editor
-people that don't try
-when people use excel as a word processor
-people here at work that think I'm the one they should ask IT questions
 
-when people use excel as a word processor
That'd be me. :lol:

And I had sorta the same question for Dom: Not a morning person I take it?
(Good point about the vegetarians' consideration for the rest of us too.)

As for what really chaps my @ss?. . .
Pinheads who don't hit their turn signals until they're already turning the wheel.
Honestly, I don't need a signal to tell me you're turning: I can see that you're turning.
What I want is a signal telling me you're GONNA turn! :roll:
 
As for what really chaps my @ss?. . .
Pinheads who don't hit their turn signals until they're already turning the wheel.
Honestly, I don't need a signal to tell me you're turning: I can see that you're turning.
What I want is a signal telling me you're GONNA turn! :roll:
~HalfAce
:evil: Oh!!! That's gotta be one of my top 5 too! :evil: It really frosts my .... when they're coming from the left and you want to turn left and there's traffic coming from the right but there's enough time to get out there if you could go *now*. But noooooo, Mr. Dipstick-on-the-left has you pinned there and then - like you said, signals his turn 10 feet from the corner - and now it's too late 'cause the car coming from the right has closed the gap and you get to sit for another couple of minutes! [Brits please mentally reverse all the left and right stuff.] Oh, makes my blood boil just thinking about it!
 
Yeah okay, I have to admit I'm not great at mornings. Far better now than I used to be though. I've probably been disciplined in almost every job I ever had for my timekeeping. The joys of flexi-time!!!

-when people use excel as a word processor

This made me laugh though. In my last job everyone used Excel to write letters. It wasn't as if the guys who worked there knew how to use Excel that well either so why they chose this ahead of Word I've no idea.
 

Forum statistics

Threads
1,222,697
Messages
6,167,702
Members
452,132
Latest member
Steve T

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top