identify missing data b/t columns and then paste in anthoer column

L

Little Pete

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to pull in data from rows and columns if there are blanks? 0
Error in Excel 8
changing rows *and* columns in automatic formulae 1
Create if partial match then copy and paste data from one cell to another 1
Compare & align 2 cols of Employee Names in sorted alpha order withVBA 4
sumif to work with times along a row 2
Search all instances of word and retrieve column data 1
help with copying data from many columns into one long column 0

Top