Hello,
I have a table such as this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Apples[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]27[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]28[/TD]
[/TR]
</tbody>[/TABLE]
How do I output the nth smallest unique value if column A is "Apples"?
The array formula I have to output the 3rd smallest NONunique value is as follows:
=SMALL(IF(A:A="Apples",B:B,""),3)
This returns a value of 26 because it is not considering a unique value. How do I get it to return 27?
Thank you for your help!!
I have a table such as this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Apples[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]27[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]28[/TD]
[/TR]
</tbody>[/TABLE]
How do I output the nth smallest unique value if column A is "Apples"?
The array formula I have to output the 3rd smallest NONunique value is as follows:
=SMALL(IF(A:A="Apples",B:B,""),3)
This returns a value of 26 because it is not considering a unique value. How do I get it to return 27?
Thank you for your help!!