| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
include in new column only if present in both columns
i have two list of names of 500 to 1000 in size that are in two different
columns. I would like to generate a new column with names that are only present in both list of names. help. thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
include in new column only if present in both columns
This probably isn't exactly what you want but your certainly welcome to try it.
If your first list is in column A and your second is in B1:B1000, in C1 you could put: =IF(ISERROR(VLOOKUP(A1,$B$1:$B$1000,1,0)),"",A1) Then copy the formula down thru the last row of A column data. You will end up with blanks in column C where a value from column A is not in column B. Also if a given value can exist more than once in column A you could have duplicates in column C. If there are no duplicates, at worst you'd just need to copy column C over to a blank sheet and sort it to get rid of the blanks Will "jb" wrote: i have two list of names of 500 to 1000 in size that are in two different columns. I would like to generate a new column with names that are only present in both list of names. help. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to parse column data only when text is present | Excel Worksheet Functions | |||
| how to define how may rows or columns are present in excel 03 | Excel Discussion (Misc queries) | |||
| Sum columns only if certain value is present | Excel Discussion (Misc queries) | |||
| How do I make sure all empty columns are present in a .csv file? | Excel Worksheet Functions | |||
| SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions | |||
Hybrid Mode
