Difference in cells

[drosew]

I need to pull what data is different in two cells - I have ~600 rows to go through so a function or formula would work best.

Cell A1 has:

A00111, 10857, 10858, 10348, 10859, 10860, 10869, 6007A

Cell B1 has:

A00111, 10857, 10858, 10859, 10860, 10869

I'm trying to extract what is different and which one has the extra data. I've been able to tell which one has more by doing a simple COUNTA but that doesn't help me extract what data is different.

Thanks for any help one this.

[sandy666]

I think you need VBA:

in standard module:

Please Login or Register  to view this content.

usage with your example A1, B1:

Please Login or Register  to view this content.

edit:
usage in both direction: A1->B1 or B1->A1

Please Login or Register  to view this content.