Hey, so i need help with a formula.

I need a formula that detects duplicates in a list.If the item has already appeared in the list then it should be displayed on the same row, if not then it should display not available.

I'll give 20fg for the solution(or pm me if this is inadequate). Thanks in advance!

This post was edited by Shadow_lad on Jul 19 2013 12:32am

really? nobody?

not really sure what you want to happen when you have duplicates, but here is one way:



or maybe you want to reverse the logic, not sure

This post was edited by Azrad on Jul 19 2013 05:39pm