#### Fin Fang Foom

##### Well-known Member

- Joined
- Mar 20, 2005

- Messages
- 598

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