R
Rakesh Gupta
I am using the below formula and it is working fine.
{=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10=$F$3,ROW($B$1:$B$10)),1))}
Now I want to check two conditions in this array formula.
for e.g.
IF($A$1:$A$10=$F$3
and
IF($C$1:$C$10=$E$3
Please Help
{=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10=$F$3,ROW($B$1:$B$10)),1))}
Now I want to check two conditions in this array formula.
for e.g.
IF($A$1:$A$10=$F$3
and
IF($C$1:$C$10=$E$3
Please Help