=IF(ISERR(SMALL(IF(COUNTIF(rngB,rngA)=0,ROW(INDIRE CT("1:"&ROWS(rngA)))),ROWS($1:1))),"",INDEX(rngA,S MALL(IF(COUNTIF(rngB,rngA)=0,ROW(INDIRECT("1:"&ROW S(rngA)))),ROWS($1:1))))

ctrl+shift+enter, not just enter
copy down as far as needed


"Steve" wrote:

I have a column of 40 names (A3:A43)
In column B, I have only 10 of those names
I'd like column C to show what names are not listed in column B ( the other
30 )

Much thanks,

Steve