Filtering Data in ranges and changing duplicate cells to a color
I use 2003 and need to know how to change the color of a duplicate field so
that it will alert me there is a duplicate. |
Filtering Data in ranges and changing duplicate cells to a color
Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx looneylmt wrote: I use 2003 and need to know how to change the color of a duplicate field so that it will alert me there is a duplicate. -- Dave Peterson |
Filtering Data in ranges and changing duplicate cells to a col
That worked, thanks, the only thing is that there are about 200 numbers that
it has to compare and now it is slow. I may just filter it instead. Thanks. "Dave Peterson" wrote: Chip Pearson has lots of techniques to work with duplicates: http://www.cpearson.com/excel/Duplicates.aspx looneylmt wrote: I use 2003 and need to know how to change the color of a duplicate field so that it will alert me there is a duplicate. -- Dave Peterson |
All times are GMT +1. The time now is 04:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com