| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Dec | Feb » | |||||
| 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’ve just made this easy to use data encryption tool. The encryption algorithm is taken from Rob Bovey’s site.
You can drop your data on to the worksheet (you can add extra worksheets too if you like) and then encrypt the data with the press of a button. You will be asked to provide a key, […]
There’s a new blog in town! Simon Murphy of www.codematic.co.uk has sparked up the old blogging elbow and put figure to keyboard. As you might expect there is some excellent and very interesting content from a very experienced Excel consultant. Check it out here!
Given the list of values 1,2,3,4,1,2,5, an Excel Data>Advanced Filter>Unique Records Only will return a filtered list of 1,2,3,4,5. But 1 and 2 are clearly not unique!
In fact this is often the result we want but still that check box should say, “List unique records and none unique records only once” (or something!)
Further it’s a […]