FILTER the data

[Techtrend]

Hi Team

Attached is the Excel and details mentioned in the doc also

A-E has data,B,C,D,E has conditions,
We should filter the A scripts as and when any data comes in B,C,D,E.

G-K has the scripts which are filtered from A-E.

Thanks for your time
Naren

 

[Monty]

Techtrend

Little confusion for me..correct me if am wrong.
You wanted to filter A to E column at the same time G to K with same parameters?

 

[Villalobos]

Hi Techtrend,

Do you need something like this?

 

[Techtrend]

A scripts are fixed there are about 90 scripts in A col ,

B,C,D,E values comes on few conditions which is already done,

Now from 90 scripts in A Col We need to filter the A Col scripts
if any of the Conditions or any value comes in B,C,D,E Col.

And publish it in G-K Col.

Let me know if you need more Clarifications.

Thanks
Naren

 

[bosco_yip]

Try,

1] Helper column F, F2 formula copy down :

=IF((4-SUM(COUNTIF(B2:E2,{""," "})))>0,MAX(F$1:F1)+1,"")

2] G2 formula copy down :

=IFERROR(INDEX(A$2:A$20,MATCH(ROWS($1:1),F$2:F$20,0)),"")

3] H2 formula copy across and down :

=IF(G2="","",INDEX($B$2:$E$20,MATCH($G2,$A$2:$A$20,0),MATCH(H$1,$B$1:$E$1,0)))

Regards
Bosco

 

[Techtrend]

Hello Bosco

Thank you so much.
Its Brilliant.

Thanks Again for your time
Naren