| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find a value in one column that is not in another column in
Hello:
I have two columns. Not all of the values in the first column are in the second column. (Some are, some aren't.) What formula in Excel can I use to say "hey, return the values from the first column that are not in the second column"? Thanks! childofthe1980s |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to find a value in one column that is not in another column in
You can mark then
assume column A and column M in B1 =countif(M:M,A1) then drag fill down the column. -- Regards, Tom Ogilvy "childothe1980s" wrote: Hello: I have two columns. Not all of the values in the first column are in the second column. (Some are, some aren't.) What formula in Excel can I use to say "hey, return the values from the first column that are not in the second column"? Thanks! childofthe1980s |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
| compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
| Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
| To find Multiple values in column B for a unique value in column A | Excel Worksheet Functions | |||
| How to find the most recent date in a column based on other column | Excel Worksheet Functions | |||
Linear Mode
