Show Unique results from a list only once.

Hi

I have a spreadsheet that contains a column of references. There will be repeats of the same reference, and in the next column I need to show the reference but only once, when it repeats it's not shown.

Also, the duplicated references won't ordinarily be grouped together, they will be scattered throughout the column.

The sample enclosed is very basic but my original data has extra columns, and the unique reference has other workings based around it, so not as simple as just removing duplicates, or filtering. The original column needs to remain in place without being altered.

Any ideas?

thanks
Barry

Maybe

Formula:

Please Login or Register  to view this content.

Afraid not. Whilst that shows the unique values, I need the value on the same row as the original, but only one time.

eg;


3 SOD-001 SOD-001
4 SOD-003 SOD-003
5 SOD-006 SOD-006
6 SOD-003
7 SOD-001
8 SOD-006
9 SOD-003
10 SOD-008 SOD-008

This is Row, Reference, Result

Result only shows in the first instance of Reference, all other instances of Reference are blank.

Thank you both, these work so will try and figure out what they are doing so I can amend later if needs be :D

I need to go and see what LAMBDA does!

thanks again.

Glad to help & thanks for the feedback.