Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to build effective IF Statement for recurring value in cells....sensitivity analysis
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sensitivity analysis | New Users to Excel | |||
Sensitivity analysis | Excel Worksheet Functions |