How to find names in a column from a smaller list of names in another column, plus mark for sorting
Hello all.
To demonstrate (screenshot enclosed), I have a list of names in column A and a smaller list in column D.
Is there a formula that can be placed in column B to find the matching names of col. A & D and place text “Fix” in the corresponding B cell?
My objective is to sort the sheet by column B, so that all the rows that need fixing are listed together. My real list has 600+ rows. I am hoping to save time and work.
In the image the names in purple demonstrate the matching titles.
I appreciate any assistance.
cheers
Hello all. To demonstrate (screenshot enclosed), I have a list of names in column A and a smaller list in column D.Is there a formula that can be placed in column B to find the matching names of col. A & D and place text “Fix” in the corresponding B cell? My objective is to sort the sheet by column B, so that all the rows that need fixing are listed together. My real list has 600+ rows. I am hoping to save time and work. In the image the names in purple demonstrate the matching titles.I appreciate any assistance.cheers Read More
