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 |
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 |
All times are GMT +1. The time now is 08:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com