ACTUALLY, just to be sure, did you want me to paste this formula in cell C1
and copy it down column C? because if so, now that I look at what it's doing
it is NOT giving me the list in column B minus what's in column A ... hmmm

"Peggy Shepard" wrote:

Hi Ralph,

=IF(A1<"",IF(COUNTIF(A:B,A1)1,"",A1),IF(INDIRECT (ADDRESS(ROW()-MATCH("",A:A,-1),2))<"",IF(COUNTIF(A:B,INDIRECT(ADDRESS(ROW()-MATCH("",A:A,-1),2)))1,"",INDIRECT(ADDRESS(ROW()-MATCH("",A:A,-1),2))),""))

This assumes that list A is in column A, list B is in column B, and that the
only blank cells are at the end of each list - otherwise will need a way to
trap where each list ends, a unique qualifier.

Peggy

"Ralph" wrote in message
...
Hi,

I have several massive lists that I need some excel kung fu help with.
Best
way to explain the challenge is with an example. I have lists A & B and
want
to make list C as follows:

list A - dog, cat, ball, orange, cloud, peppers
list B - hockey, beer, smart, rain, ball, ocean

list C needs to be list B with any entries that are also in list A
removed,
in this case "ball" needs to be removed, so list C becomes

list C - hockey, beer, smart, rain, ocean

comprende'? can anyone PLEASE HELP with this?

Thanks!

p.s. these lists are 5 to 10k worth of entries long in columns