return multiple values when within range (greater than and less than)
Hi,
Am Wed, 14 Aug 2013 18:08:54 +0100 schrieb sporenta:
Thanks for the suggestions. That last one is returning non-error
results, but too many, unfortunately. When I SHFT+CNTRL+ENTER:
=INDEX(A$1:A$150,SMALL(IF((B$1:B$150<4)+(B$1:B$150 =3),ROW($1:$150)),ROW(A1)))
..it returns all the names, not just the ones that fall between 3 and
4.
I thought you want the names <3 and =4.
For the names between 3 and 4 try:
=INDEX($A$1:$A$150,SMALL(IF(($B$1:$B$150=3)-($B$1:$B$1504),ROW($1:$150)),ROW(A1)))
and CTRL+Shift+Enter
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|