Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Differences between two columns.
Does anyone out there know a simpleway to compare the values in two different
columns on an Excel spreadhseet and pick out all of the cells in the first number that have a value that the second column doesn't have? Thanks. |
#2
|
|||
|
|||
Say your two columns are A and C (of the same worksheet).
Put this in B1 and drag down to the length of column A: =isnumber(match(a1,c:c,0)) Apply data|filter|autofilter to column B. True = there's a match false = no match Chip Pearson has lots of ways to work with duplicates/uniques at: http://www.cpearson.com/excel/duplicat.htm Mr. Smiley wrote: Does anyone out there know a simpleway to compare the values in two different columns on an Excel spreadhseet and pick out all of the cells in the first number that have a value that the second column doesn't have? Thanks. -- Dave Peterson |
#3
|
|||
|
|||
i use the formula =exact() for this.
"Mr. Smiley" wrote: Does anyone out there know a simpleway to compare the values in two different columns on an Excel spreadhseet and pick out all of the cells in the first number that have a value that the second column doesn't have? Thanks. |
#4
|
|||
|
|||
What if the columns are on different worksheets of the same workbook?
"paige" wrote: i use the formula =exact() for this. "Mr. Smiley" wrote: Does anyone out there know a simpleway to compare the values in two different columns on an Excel spreadhseet and pick out all of the cells in the first number that have a value that the second column doesn't have? Thanks. |
#5
|
|||
|
|||
Does anyone out there know a simpleway to compare the values in two
different columns on an Excel spreadhseet and pick out all of the cells in the first number that have a value that the second column doesn't have? Thanks. One way is to use conditional formatting. Suppose the first column is A and the second is B. Select A1 and use Format Conditional formatting Formula is Then put for the formula =COUNTIF(B:B, A1)=0 Then click Format Patterns And choose a background color of your choice, followed by clicking OK and OK again. Finally, with A1 still selected, click the paintbrush and then spread the paint down the list of values in column A; this paints the conditional formatting onto those cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Compare 2 columns to see differences | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Counting differences in numbers across columns | Excel Worksheet Functions |