http://www.xlninja.com/2012/07/18/how...
Often you will have a set of data with duplicate values due to typing errors.
How do you find those duplicate values easily so that you can remove them?
The idea for this video was generated by this discussion on the Microsoft Excel Users group on Linkedin http://lnkd.in/eQTUi6
With thanks to Craig Hatmaker / 444
and
Pankaj Mishra / 3b4