Fin Fang Foom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 598
Hi everyone,
I have this formula below it will retrieve unique vaules and sort them in a Ascending order.
=INDEX($A$2:$A$1000,MATCH(SUM(COUNTIF($A$2:$A$1000,C$1:C1)),COUNTIF($A$2:$A$1000,"<"&$A$2:$A$1000)+ISTEXT($A$2:$A$1000)*SUM(--ISNUMBER($A$2:$A$1000))-ISBLANK($A$2:$A$1000),0))
But I would like to add a condition in the formula. If greater or equal to 3 and Less or equal to 9.
I tried to modifed it but no luck.
=INDEX($A$2:$A$1000,MATCH(SUM(COUNTIF($A$2:$A$1000,C$1:C1)),IF($A$2:$A$1000>=3,IF(A$2:A$1000<=9,COUNTIF($A$2:$A$1000,"<"&$A$2:$A$1000)+ISTEXT($A$2:$A$1000)*SUM(--ISNUMBER($A$2:$A$1000))-ISBLANK($A$2:$A$1000),0))))
The expected results I'm looking for are in column E
I have this formula below it will retrieve unique vaules and sort them in a Ascending order.
=INDEX($A$2:$A$1000,MATCH(SUM(COUNTIF($A$2:$A$1000,C$1:C1)),COUNTIF($A$2:$A$1000,"<"&$A$2:$A$1000)+ISTEXT($A$2:$A$1000)*SUM(--ISNUMBER($A$2:$A$1000))-ISBLANK($A$2:$A$1000),0))
But I would like to add a condition in the formula. If greater or equal to 3 and Less or equal to 9.
I tried to modifed it but no luck.
=INDEX($A$2:$A$1000,MATCH(SUM(COUNTIF($A$2:$A$1000,C$1:C1)),IF($A$2:$A$1000>=3,IF(A$2:A$1000<=9,COUNTIF($A$2:$A$1000,"<"&$A$2:$A$1000)+ISTEXT($A$2:$A$1000)*SUM(--ISNUMBER($A$2:$A$1000))-ISBLANK($A$2:$A$1000),0))))
The expected results I'm looking for are in column E