Funny/Strange things you find in Excel Help Files

When I eventually get round to having enough work to take on full-time employees, I will state in contract terms that a significant proportion of income (bonus) is based on achieving 30 posts per month (average) among my preferred excel forums!
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Put my name down. :)
 
Oh, then never mind. ;)
 
I'm not going to pay £ per post Rory. You'd bankrupt us! :stickouttounge:

You could probably pay Rory in ale! Every x-amount of posts, he gets one! And what is great is that by maintaining his inebriation, his posts will be amazing!

ballmer_peak.png
 
Shame my normal state is over .26 I guess.
 
That window ('blip') that you showed is actually very narrow for my intake of gin. Sensible answers from me can only be expected from 19:10 to 19:20.
 
Not odd or inefficient, but just plain wrong – Excel 2007 help files on dates:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
01/01/2008 is serial number 39,448 because it is 39447 days after 01/01/1900. You could call me pedantic, but it matters!

<o:p></o:p>

Actually, it's 39446 days after 1/1/1900 : day 60 (2/29/1900) never happened.
 

Forum statistics

Threads
1,223,762
Messages
6,174,357
Members
452,558
Latest member
jswan83

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