Filter 4 columns at once

[yuvalshabt]

Hi guys,

I have an excel file with inventory availability in 4 different warehouses:
[TABLE="width: 500"]
<tbody>[TR]
[TD]warehouse 1
[/TD]
[TD]warehouse 2
[/TD]
[TD]warehouse 3
[/TD]
[TD]warehouse 4
[/TD]
[/TR]
[TR]
[TD]Y
[/TD]
[TD]Y
[/TD]
[TD]Y
[/TD]
[TD]Y
[/TD]
[/TR]
[TR]
[TD]Y
[/TD]
[TD]N
[/TD]
[TD]Y
[/TD]
[TD]N
[/TD]
[/TR]
[TR]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[/TR]
[TR]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]Y
[/TD]
[/TR]
</tbody>[/TABLE]

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