help./

  • Thread starter Thread starter pierre
  • Start date Start date
P

pierre

hello....please help me on this one :
i have the following correct formula :

=INDEX(B$1:B$7,SMALL(IF(($A$1:$A$7=$G$1)+($A$1:$A$7=$G$2)+($A$1:$A$7=$G$3),ROW(B$1:B$7)),ROWS(B$1:B1)))

is there any way to make THIS part :
if(($A$1:$A$7=$G$1)+($A$1:$A$7=$G$2)+($A$1:$A$7=$G$3) in a way to be SHORTER
????
 
=INDEX(B$1:B$7,SMALL(IF(($A$1:$A$7=TRANSPOSE($G$1:$G$3)),ROW(B$1:B$7)),ROWS(B$1:B1)))


Array entered


--


Regards,


Peo Sjoblom
 
please one more little thing :(related to my precedent issue)
how to resolve this equation in a shorter way ??
if(($A$1:$A$7="aa")+($A$1:$A$7="bb")+($A$1:$A$7="cc")

THANK YOU
 
Back
Top