|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 20th, 2009, 02:51 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
comparing 2 sheets
hey all,
i have 2 sheets that contain a column of names on both s1 john amy s2 john chris is there a way to find out, for example, names in s1 that don't exist in s2? thanks, rodchar 
|
|
#2
May 20th, 2009, 03:21 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
comparing 2 sheets
The easiest way is to use a separat column. let's assume your lists are in
column A of both, and start in cell A2 (A1 being a header) in B2 of sheet1, enter: =countif(sheet2!A:A,A2) change your sheet name and column references as needed. any with a 0 are not in the other list. You can do boh ways to capture those one either list but not on the other. "rodchar" wrote: hey all, i have 2 sheets that contain a column of names on both s1 john amy s2 john chris is there a way to find out, for example, names in s1 that don't exist in s2? thanks, rodchar
|
|
#3
May 20th, 2009, 03:38 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
comparing 2 sheets
Thanks for the help,
rod. "Sean Timmons" wrote: The easiest way is to use a separat column. let's assume your lists are in column A of both, and start in cell A2 (A1 being a header) in B2 of sheet1, enter: =countif(sheet2!A:A,A2) change your sheet name and column references as needed. any with a 0 are not in the other list. You can do boh ways to capture those one either list but not on the other. "rodchar" wrote: hey all, i have 2 sheets that contain a column of names on both s1 john amy s2 john chris is there a way to find out, for example, names in s1 that don't exist in s2? thanks, rodchar
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
