Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to compare one column to another?
Hi everyone,
I have two columns of strings, both in ascending order. Similar lists but not identical. Are there macros or other steps I can take to compare column A with column B, so that all entries in A that aren't in B wind up in column C? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to compare one column to another?
Hello
If your list in column A is from A1 to say A6 and list in B is from B1:B6 then enter the following in C1 and copy it down to C6 =IF(COUNTIF($B$1:$B$6,A1)0,"",A1) Alok "Jim Bancroft" wrote: Hi everyone, I have two columns of strings, both in ascending order. Similar lists but not identical. Are there macros or other steps I can take to compare column A with column B, so that all entries in A that aren't in B wind up in column C? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to compare one column to another?
Hi,
Unfortunately the columns don't have the same number of rows. What's more, some entries in column A aren't in column B, and vice versa. "Alok" wrote in message ... Hello If your list in column A is from A1 to say A6 and list in B is from B1:B6 then enter the following in C1 and copy it down to C6 =IF(COUNTIF($B$1:$B$6,A1)0,"",A1) Alok "Jim Bancroft" wrote: Hi everyone, I have two columns of strings, both in ascending order. Similar lists but not identical. Are there macros or other steps I can take to compare column A with column B, so that all entries in A that aren't in B wind up in column C? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to compare one column to another?
Hi Jim,
The formula does not require the same number of rows in columns A and B. For instance your column A could be A1:A1000 and entries in B from B1:B500. Then the formula in C1 will become =IF(COUNTIF($B$1:$B$500,A1)0,"",A1) but it will still need to be copied down till C1000. Hence the column C must (in my solution) have the same number of rows as in column A - though I have seen in this newsgroup solutions that ensure that column C does not have blanks as in my solution but has only the missing entries right at the top of the column. Alok "Jim Bancroft" wrote: Hi, Unfortunately the columns don't have the same number of rows. What's more, some entries in column A aren't in column B, and vice versa. "Alok" wrote in message ... Hello If your list in column A is from A1 to say A6 and list in B is from B1:B6 then enter the following in C1 and copy it down to C6 =IF(COUNTIF($B$1:$B$6,A1)0,"",A1) Alok "Jim Bancroft" wrote: Hi everyone, I have two columns of strings, both in ascending order. Similar lists but not identical. Are there macros or other steps I can take to compare column A with column B, so that all entries in A that aren't in B wind up in column C? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
How do I compare string values in one column to another column? | Excel Worksheet Functions | |||
Compare one Column to a Second Column Formula Help Needed | Excel Worksheet Functions | |||
compare data from one column with another and compare result to yet another | Excel Programming |