Hello! I'm loosing my mind and unable to find a simple formula for this problem. Please help.
- one excel file ,
- sheet 1 with many rows and columns ,
- sheet 1 , column AH is containing 4 digit numbers or text string ,
- how to identify or mark red all rows in sheet 1 , column AH , containing the same string in sheet 2 , column (array) A ?
... maybe I need to insert one column in sheet 1 and insert formula there , to insert word "yes" in rows containing sheet 2 reference?
... maybe I need a macro...
... later on I plan to use "filtering by color" to select and extract only found rows ... but this can be done as well with new column "yes"
many thanks!
Bookmarks