Excel and the terminally dim
2 examples of telephone calls I received asking for help with Excel, both absolutely true:

Q: I'm trying to get an average of these figures in column F, but every time I click the Autosum button it just adds them up.
A: That's because it's the AutoSUM button, there is no AutoAverage button. Look at the formula and replace SUM with Average.
(response: Hey, that works!)

Q: I've got an error message saying that I need to complete missing data in column B. Where's column B?
A: Well, you might find it in between column A and column C.


Also, people who on seeing the message "Book1.xls is reserved by JugglerJAF. Enter the password for write access or open as Read Only" only read the first part of the message and automatically assume that it means that I'm in the file and then call me up to ask me to come out of it.

NO! It's password protected so you can't bollox it up. Just open it as Read Only.
( JugglerJAF It's curtains for you.Lacy gently wafting curtains, Mon 5 May 2008, 14:51, Reply)