Not sure who reads this, or who know sof my sick little Microsoft Excel fetish. I love the program, I know liek 1% of its features and am amazed at all the complex things it can do.
Lately I have been using it one way or another for about 4-5 hours a day I will say and occasional get a "woodrow" when a new time saving feature pops up.
I have been having to prune large sets of lists and have been able to use excels remove duplicates feature, but found it lacking. After some research I did for a an easy solution / excel macro I found this excellent free / donation ware utility. It is pretty powerful stuff andI thought I would share:
here are some features:
Works with cells or entire rows!
Runs over ranges, multiple sheets or the entire Workbook!
Highlight duplicate cells or rows
Delete duplicate cells or rows
Select duplicate cells or rows
Extract unique cells or rows to a master list
Extract and count the number of duplicate cells or rows to a master list
It is pretty awesome, and it is free! Just follow the install instruactions on that page and raise hell with removing duplicates or highlighting duplicates in excel, without using a macro.
Thanks BrettDj for the software!