| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Jun | Aug » | |||||
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |
| 31 | ||||||
I was surprised to find there was no way to display dependencies arrows for a selection using the Formula Auditing tool bar. I don’t use it a lot, but I would have though that this is the sort of thing it should be able to do. Now, I also know that there are quite a [...]
Recently I have been thankful for a couple of Office features which help with damaged files. I think both of the following first appeared in Office XP. The first is extremely strange and was unknown to me until very recently.
On the “About Microsoft Excel” [under the help menu) there is a “Disabled Items” button. Why [...]
This is very cool! and as it's the world cup!!!!
http://www.xlfootymanager.co.uk/
It struck me today that the DGET function might be the most useless fuction in the whole of Excel, this is from the help file:
DGET
Extracts a single value from a column of a list or database that matches conditions you specify.
Syntax DGET(database,field,criteria)
...
Remarks
If no record matches the criteria, DGET returns the #VALUE! error value. If more [...]