Rory

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
No thanks... I have a dog.
That will suffice thank you very much (just don't tell the wife I said that).
 
My son's adorable - except when the little sod chucked water over my home computer. He was lucky - I checked out the legal position online, and apparently even such actions don't justify infanticide...
 
My dog walks over my laptop but in fairness she's trying to get to grips with SUMPRODUCT...
 
My dog walks over my laptop but in fairness she's trying to get to grips with SUMPRODUCT...
Yes, that tricky SUMPRODUCT formula has been a source of great frustration to many a pooch...
 
Yes, she came up with this yesterday:

=LOOKUP(SUMPRODUCT(--(DinnerBowl="Empty"),--(Watch>=TIME(17,0,0)),--(Watch<=TIME(17,0,5))),{0,1},{"Nap Time!","Dinner Time!"})
 
I wasn't aware, but I am now (thanks, Nate). :)
And as much as I love my EE Genius T-shirt, that just proves I don't spend enough time doing actual work... :biggrin:

Hey Rory,
I use my T-shirts when I do work in the yard:-)
Cal

PS-Welcome to the light side of the excel forums, where everything is FREE!!!
 
Last edited by a moderator:
PS-Welcome to the light side of the excel forums, where everything is FREE!!!
Thanks! EE is the only forum I frequent where people may have to pay and I never leave the Excel TA as it seems to be the only zone that has a 'free forum' feel to it!
 
rorya, since this thread is about you, feel free to answer the following :biggrin:

can you explain your quote in your signature?
"Un petit d'un petit S'étonne aux Halles
Un petit d'un petit Ah! degrés te fallent"
 

Forum statistics

Threads
1,222,681
Messages
6,167,581
Members
452,120
Latest member
Luis_Macros

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