I saw this thread

http://www.excelforum.com/excel-gene...-for-name.html


inside is a formula which i cant seem to figure out on my own (and im normally pretty good) 

Please Login or Register  to view this content.
its used to list a unique set of names.

i would be very thankful if someone could take a few minutes to explain the theory and how this works.