Hi there,

I'm a beginmner, trying to use formula's for (almost) the first time.
In colum A I have about 220.000 barcodes
eg:
0000040151595
0000040151595
0000040151601
0000050936885
0000050936885
0000050936915
0000050936922
0000050953127
0000087189025
0000087189025
0000087189032
0000087189032
0000087189049
0000087189049
0000087189056
0000087189056
0010343602229
0010343602229
0010343602236
0010343602236
Many of those barcodes are unique, but many more have doubles.
By using data/sort, I sorted the barcodes, so that the double barcodes
are standing side by side in the colum.
Now I'm looking for a formula that picks out the stand alone barcodes,
But I don't know how to create a formula like that.

EG:
If cel A2 equals A1 OR If Cel A2 equals A3, the two cells that equal
should remain where they are.
If cel A2 does not equal A1 and does not equal A3 it should copy itself
another page.

Can anybody tell me what to do?

Thanks