Help with deleting duplicate values in a list

[rorshil]

EXCEL QUESTION.png

Hi, I'm looking for a way to delete the duplicate values that result from this formula.

Is there a way to say "if the value is the second or higher instance of the data in C2, display nothing?


Thanks

[KOKOSEK]

If I am correctly read you needs:

Please Login or Register  to view this content.

probably is better way but it works.

[rorshil]

thanks, that works great