dmoore86088
New Member
- Joined
- Jun 27, 2014
- Messages
- 12
Hello team,
I work with some extremely large excel files. One of the things that I have to do is to compare thousands of account numbers from different sources to find all that are common. Right now, I use Conditional Formatting -> Highlight Cells Rules -> Duplicate values. Once all matching account numbers are highlighted, I sort by color, so that they are all in one place. This takes an extremely long time!!
Is there a better way of identifying the same account numbers, and then collecting them all in one place? Is there a 'count by color' formula?
Many thanks!!
I work with some extremely large excel files. One of the things that I have to do is to compare thousands of account numbers from different sources to find all that are common. Right now, I use Conditional Formatting -> Highlight Cells Rules -> Duplicate values. Once all matching account numbers are highlighted, I sort by color, so that they are all in one place. This takes an extremely long time!!
Is there a better way of identifying the same account numbers, and then collecting them all in one place? Is there a 'count by color' formula?
Many thanks!!