Comparing value in multiple columns
 

Hello,
What is the best way to see if there are any differences in the values for
numerous colunms, excluding any blank cells? There are 24 columns, including
columns with blank values. Couldn't get if statement to work... Example:
IBLITM CA03 CA01 CA02 CA04
000000103 31 31 31 31
000000309 31 31 31 31
000000701 31 31 31 31
000000804 31 31 31 31
000001104 31 31 31 31

Comparing value in multiple columns
 

Are you wanting to highlight, delete or produce a report on the IBLITM that
is different? What version of excel?

If you are using excel 2007, try the conditional forumal to locate
duplicates and select a to change fill color to say red.

found this on the 2007 "Excel Help"

To filter for unique values, use the Advanced command in the Sort & Filter
group on the Data tab.
To remove duplicate values, use the Remove Duplicates command in the Data
Tools group on the Data tab.
To highlight unique or duplicate values, use the Conditional Formatting
command in the Style group on the Home tab.

"tarbrook" wrote:

Hello,
What is the best way to see if there are any differences in the values for
numerous colunms, excluding any blank cells? There are 24 columns, including
columns with blank values. Couldn't get if statement to work... Example:
IBLITM CA03 CA01 CA02 CA04
000000103 31 31 31 31
000000309 31 31 31 31
000000701 31 31 31 31
000000804 31 31 31 31
000001104 31 31 31 31

Comparing value in multiple columns
 

Thank you for the response! Those tips are very useful!
I'm using 2002...
To clarify, for each IBLITM, all CA columns should match...I need to be able
to identify which IBLIITMs have different CA values, if that makes any
sense...

"Donna" wrote:

Are you wanting to highlight, delete or produce a report on the IBLITM that
is different? What version of excel?

If you are using excel 2007, try the conditional forumal to locate
duplicates and select a to change fill color to say red.

found this on the 2007 "Excel Help"

To filter for unique values, use the Advanced command in the Sort & Filter
group on the Data tab.
To remove duplicate values, use the Remove Duplicates command in the Data
Tools group on the Data tab.
To highlight unique or duplicate values, use the Conditional Formatting
command in the Style group on the Home tab.

"tarbrook" wrote:

Hello,
What is the best way to see if there are any differences in the values for
numerous colunms, excluding any blank cells? There are 24 columns, including
columns with blank values. Couldn't get if statement to work... Example:
IBLITM CA03 CA01 CA02 CA04
000000103 31 31 31 31
000000309 31 31 31 31
000000701 31 31 31 31
000000804 31 31 31 31
000001104 31 31 31 31

Comparing value in multiple columns
 

This was very useful, however I have a slightly different situation:

Using the table provided for reference: If I want to compare column 2 to
column 3 in all rows (100+), would I have to enter a conditional format for
each row, or is there another way to enter the comparision?

"Donna" wrote:

Are you wanting to highlight, delete or produce a report on the IBLITM that
is different? What version of excel?

If you are using excel 2007, try the conditional forumal to locate
duplicates and select a to change fill color to say red.

found this on the 2007 "Excel Help"

To filter for unique values, use the Advanced command in the Sort & Filter
group on the Data tab.
To remove duplicate values, use the Remove Duplicates command in the Data
Tools group on the Data tab.
To highlight unique or duplicate values, use the Conditional Formatting
command in the Style group on the Home tab.

"tarbrook" wrote:

Hello,
What is the best way to see if there are any differences in the values for
numerous colunms, excluding any blank cells? There are 24 columns, including
columns with blank values. Couldn't get if statement to work... Example:
IBLITM CA03 CA01 CA02 CA04
000000103 31 31 31 31
000000309 31 31 31 31
000000701 31 31 31 31
000000804 31 31 31 31
000001104 31 31 31 31