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