How to build effective IF Statement for recurring value in cells....sensitivity analysis

[velocityinc]

I have a value that occurs more than once in a column. For e.g.
$400,000 in cell A15 and the same value in cells A16, A17, and so on.
I would like to include an IF statement to show only the first
occurrence of the $400,000 value, and not show any of the ones below
that. What would the IF statement be.

I have tried, =IF(a16=a15,"",a16), but this does not always work,
especially for more than 1 or 2 cells as I drag down the formula.

Any assistance would be greatly appreciated. \

Thanks,

V

 

[T. Valko]

Try this:

=IF(COUNTIF(A$15:A15,A15)>1,"",A15)

Biff