Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare
lets say i have a spreadsheet with columns A and B containing the same data.
i would like to know how i can show in column C those values not in column A as compard to column B as i take them out of column A. thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare
Let's say we have in cols A & B:
123 123 456 456 789 789 54 54 678 678 53 53 5467 5467 23411 23411 doesn't matter if numbers or words. In C1 enter: =IF(COUNTIF(A:A,B1)=0,B1,"") and copy down Now if you remove a value from column A: 123 123 456 456 789 789 54 54 678 678 5467 53 53 23411 5467 23411 Column C will show the removed value. -- Gary''s Student - gsnu200742 "geebee" wrote: lets say i have a spreadsheet with columns A and B containing the same data. i would like to know how i can show in column C those values not in column A as compard to column B as i take them out of column A. thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
String compare doesn't compare? | Excel Programming | |||
Compare.xla | Excel Programming | |||
compare | Excel Programming | |||
compare data from one column with another and compare result to yet another | Excel Programming |