How to build effective IF Statement for recurring value in cells....sensitivity analysis
Try this:
=IF(COUNTIF(A$15:A15,A15)1,"",A15)
Biff
wrote in message
oups.com...
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
|