Extract entire row with 3 conditions.

Hello Friends

Please find the attached file (Extract entire row with 3 conditions.xlsx).

I need to plot the entire row with 3 conditions.

If the given inputs matching to Column C and Column G and if the Column A is filled i.e., un blank then the entire row needs to be filled.

thanks in advance.

Originally Posted by johntopley

(($c$1:$c$192=$i$5)+($c$1:$c$192=$i$6)+($c$1:$c$192=$i$7)+($c$1:$c$192=$i$8)+($c$1:$c$192=$i$9))

That can be reduced to:

--ISNUMBER(MATCH($C$1:$C$192,$I$5:$I$9,0))

Modified formula thanks to Tony in Post #3

=IFERROR(INDEX($A$1:$A$192,SMALL(IF((--ISNUMBER(MATCH($C$1:$C$192,$I$5:$I$9,0)) )*(--ISNUMBER(MATCH($G$1:$G$192,$J$5:$J$6,0)))*($A$1:A$192<>""),ROW($A$1:$A$192)-ROW($A$1)+1,""),ROWS($1:1))),"")

Entered with Ctrl+Shift+Enter

I have changed formula in first column to be as above. Others need changing (ranges) as per my earlier post.

I think this can be accomplished with slicers. Convert the data range to an Excel Table and then insert slicers for Columns C & G.

Hello Biff , JohnTopley and dflak

Thanks for the solutions. Formulas are working well. I need to learn about slicers and again i need to upgrade to 2013 from 2010.

thanks again

You're welcome. We appreciate the feedback!