Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
identify missing data b/t columns and then paste in anthoer column
hi all,
I would like to compare two columns of data (alpha & numeric) - List A and List B, against one another and identify those data that are missing from List A and then paste this data into a new column with no blank cells between them. I am playing around with something like the following but not having much joy; =IF(B2="","",IF(ISNUMBER(MATCH(B2,'Enter SURVEY DATA'!B:B,0)),"",ROW())) and then =IF(ISERROR(SMALL('Enter CORVU DATA'!E:E,ROW('Enter SURVEY DATA'!B2))),"",INDEX('Enter SURVEY DATA'!B:B,MATCH(SMALL('Enter CORVU DATA'!E:E,ROW('Enter SURVEY DATA'!B2)),'Enter CORVU DATA'!E:E,0))) thanks very much pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|