formula to return one value only

[p4nny]

Hi,

I have performed a vlookup to bring the in the figures I require... The only problem is that there's many duplicates (but I can't remove the duplicates as the data is used for other function.

I would like the vlookup to do the following:

Column A is how the data lookups now but I would like it look like column B in showing one value only.. A pivot table would be ideal but this is summary tool.

A B
12312 12312
12312 0
12312 0
12312 0
87987 87987
87987 0
87987 0
45647 45647
45647 0
45647 0

 

[steve the fish]

Im presuming your data is already there in column A? Its a bit confusing what you are asking for but this formula will produce the 2nd list with the first list in A1:A10. Put it in B1 and copy down.

=IF(COUNTIF($A$1:A1,A1)>1,0,A1)