19 January 2007 by Ross McLean
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, which you must remember. Save the file and send it out.
The receiver can then contact you for the key. When they click the decrypt button it will ask them for the key, if they enter it correctly it will return the original data. If they enter the wrong key the data will be encrypted again.
I have not tested this much, so make sure you back up your originals and remember there is not such thing a truly save data!
If you have any questions or suggestions drop me a comment.
Enjoy!
Tags: Data, Downloads, Examples, VBA
Categories: Downloads •
1 Comment »
17 January 2007 by Ross McLean
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!
Tags: Blogs, News!
Categories: News! •
2 Comments »
16 January 2007 by Ross McLean
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 bit of a pain to do a pivot table of a filter all the time so why has Excel not got a function to do this!!! =countunique(range)!
Well ExcelTip.com offers a solution here in the form of a UDF, which is quite fast and work just like the advance filter does. Handy.
For a truly unique experience though, you’ll have to visit here, be warned it’s a slow old dog and if you intend to use it a lot you need to write a C++ function really.
Does anyone know other FUNCTIONS that will get this job done?
PS, don’t forget to check out Ron de Bruin’s Easy Filter Addin an excellent tool!
Tags: Examples, VBA
Categories: UDF •
No Comments »
