I have an excel spreadsheet with 8 columns. I need to compare multiple columns and rows, can this be done in Excel?
I need to:
- Compare values in column A and find matches
- If duplicates in column A, compare values in Column B to make sure they are not duplicates.
- Then compare value in column F in row 1 to value in column D in row 2 to see if they are with 1 day (both columns contain dates).
Is this too complicated for Excel?