I have a list of 20 phone numbers in column Q. I need see if those numbers appear in column F (there are hundreds of rows)and if they do, highlight the respective cell in column F and place a count next to column Q. I know that I can do this 1 at a time but there has to be a function to allow this to be automated.
Can anyone help?
Bookmarks