Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing multiple columns in two sheets | Excel Worksheet Functions | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
comparing multiple columns | Excel Worksheet Functions | |||
comparing multiple columns | Excel Worksheet Functions | |||
Comparing multiple columns | New Users to Excel |