Comparing columns in Excel 2010
Solved/Closed
Laulou95
laulou95 - Nov 22, 2015 at 11:15 AM
- Posts
- 1
- Registration date
- Friday November 13, 2015
- Status
- Member
- Last seen
- November 13, 2015
laulou95 - Nov 22, 2015 at 11:15 AM
Related:
- Comparing columns in Excel 2010
- Compare columns in excel ✓ - Forum - Excel
- Compare two columns in excel for partial matches - Guide
- Excel - Compare column A & B give results in column C - How-To - Excel
- Compare the words in 2 columns in Excel ✓ - Forum - Excel
- A variation on the compare 2 columns in Excel ✓ - Forum - Excel
1 reply
rizvisa1
Nov 13, 2015 at 10:00 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Nov 13, 2015 at 10:00 AM
You can use conditional format
So If you click on A1 and then select all columns till column CP
and use the formula
=AND(A1<>"", ISERROR(MATCH(A1,$CQ:$CQ,0))) and select the color you would like to see
So If you click on A1 and then select all columns till column CP
and use the formula
=AND(A1<>"", ISERROR(MATCH(A1,$CQ:$CQ,0))) and select the color you would like to see
Nov 22, 2015 at 11:15 AM
I used the conditional formatting comparing each column individually to column A. the formula was not exactly what I had in mind. However, it was very effective for another part of the project.
Thanks again.