morinia
asked on
Comparing a range of colums in Excel
Experts,
I have a range of columns B - BU. Column A has an ID.
Is there a way to highlight by a formula or VB code each column by ID where there the values are not equal with ID. There are two rows per ID.
An example is H2 and H3 and I2 and I3.
See attached spreadsheet.
Diffs.xlsx
I have a range of columns B - BU. Column A has an ID.
Is there a way to highlight by a formula or VB code each column by ID where there the values are not equal with ID. There are two rows per ID.
An example is H2 and H3 and I2 and I3.
See attached spreadsheet.
Diffs.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.