Filter 4 columns at once

[yuvalshabt]

Hi guys,

I have an excel file with inventory availability in 4 different warehouses:

warehouse 1	warehouse 2	warehouse 3	warehouse 4
Y	Y	Y	Y
Y	N	Y	N
N	N	N	N
N	N	N	Y

<tbody>
</tbody>

Y means that there is inventory in stock, N means that there is none.

How do I filter those 4 columns to show the entire row even if there is only one Y in one of the warehouses?

example: line 1 will show because all Y, line 2 will show because warehouse 1 has Y and line 4 will show because warehouse 4 has Y
line 3 will not show because all is empty

Any suggestions?

Thanks!

 

[Tetra201]

Try applying the following conditional formatting rule to range A2:D5 for, say, light-green fill:

=COUNTIF($A2:$D2,"Y")

then filter by color.

 

[yuvalshabt]

Try applying the following conditional formatting rule to range A2:D5 for, say, light-green fill:

=COUNTIF($A2:$D2,"Y")

then filter by color.

Worked great. thank you!!!

 

[ahmedmirza]

Hi!

Another suggestion..

Insert the following in column E cell 2 and copy down the formula

=COUNTIF(A2:D2,"y")

Then filter column E for values greater than 1

HTH