Hello,
In my spreadsheet column A contains thousands of cells containing names , some of which are duplicate names. In column J I have a seperate list of names, some of which are also in column A. I want to highlight a cell in column A if the name in it is the same as one of the names in a cell from column J.
I need to be able to quickly look at a name in column J and be able to indicate how many time that name shows up in column B, if the name shows up at all.
This task is performed on a monthly basis so it would be great to figure out a less time consuming way of doing this.
Thank you for any help!
Bookmarks