Compare two columns

[aysam]

Peace to you all
I have two columns;each has a list of names
I need a formula to return the names that are in column A and not in column B
Hope I'm clear enough to be helped
Thanks in advance.

 

[aysam]

Thank you for you all
I was going nuts
You saved me

 

[aysam]

Once more
Hey jasonb75
Yours is so coooool
But
It returns an error (#NUM!) in the empty Cells
Would yoy Please repair
Awaiting

 

[jasonb75]

For excel 07 / 10

=IFERROR(INDEX($A$1:$A$7,SMALL(IF(ISERROR(MATCH($A$2:$A$7,$B$2:$B$7,0)),ROW($A$2:$A$7)),ROW(A1))),"")

For older versions, could probably be improved.

=IF(SUM(IF(ISERROR(MATCH($A$2:$A$7,$B$2:$B$7,0)),1))< ROW(A1),"",INDEX($A$1:$A$7,SMALL(IF(ISERROR(MATCH($A$2:$A$7,$B$2:$B$7,0)),ROW($A$2:$A$7)),ROW(A1))))

Confirm array with Shift Ctrl Enter for both versions.

 

[aysam]

Does that work or do you need an alternative for an older version?

2003 Please

 

[jasonb75]

In case you missed the edit, look back at the last reply, it's already there

 

[jeffreybrown]

Maybe worth looking at List Functions for a reference

 

[jasonb75]

Maybe worth looking at List Functions for a reference

I'm sure I remember seeing that solution before, post #2 in this thread I think

 

[aysam]

Thaks so much
You all helped me greately
Cheers