06-29-2012, 12:19 PM
|
|
Newcomer
|
|
Join Date: Jun 2012
Posts: 1
|
|
Compare two spreadsheets and delete row IF
|
I have two spreadsheets, they are almost identical except for one column.
I want to be able to search Column A of sheet1 to match Column A in sheet2.
If there is a match, I would like to search Column F in sheet2 for a certain word for the same row of the match in Column A. If that word is in column F for the matching row, I would like to delete the matching row from sheet1
Any Ideas?
|
|
Linear Mode
