Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two worksheets of data. Columns A contain the same data in each
workbook (ID #'s). I need to find out if the data in Worksheet1 Column A is in Worksheet2 Column A. I would like the rows to display a N/A if the data is not in the other worksheet. Does anyone know the formula(s) needed to get this result? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
http://www.cpearson.com/excel/Duplicates.aspx
also same site under downloads has a program called compare for downloading -- Regards, Peo Sjoblom "MikeB" wrote in message ... I have two worksheets of data. Columns A contain the same data in each workbook (ID #'s). I need to find out if the data in Worksheet1 Column A is in Worksheet2 Column A. I would like the rows to display a N/A if the data is not in the other worksheet. Does anyone know the formula(s) needed to get this result? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank-you for your help!
"Peo Sjoblom" wrote: http://www.cpearson.com/excel/Duplicates.aspx also same site under downloads has a program called compare for downloading -- Regards, Peo Sjoblom "MikeB" wrote in message ... I have two worksheets of data. Columns A contain the same data in each workbook (ID #'s). I need to find out if the data in Worksheet1 Column A is in Worksheet2 Column A. I would like the rows to display a N/A if the data is not in the other worksheet. Does anyone know the formula(s) needed to get this result? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract & compare data on different worksheets | Excel Discussion (Misc queries) | |||
compare data in 2 worksheets | Excel Worksheet Functions | |||
Compare Data in two Separate Worksheets | Excel Discussion (Misc queries) | |||
compare worksheets data | Excel Discussion (Misc queries) | |||
Compare data on 2 separate worksheets. | Excel Worksheet Functions |