Unfortunately, filters will not allow you to see one row of one column along
with multiple rows of another column.

there may be other ways to perform what you are attempting. If you provide a
desired end result, we may be able to assit in getting you there.

"Youssef B." wrote:

Hi,
I was wondering if anyone had any advice on filtering columns independently.
I have the following data:

A B

1 3
2 8
3 8
4 6
5 9

Basically, I would like to filter column A independently of column B.
I'd like to to filter column A to show only A4 (for example) and still be
able to filter column B by any criteria I like. Normally, If I filter column
A by A4, Excel only shows the value from B4 in the B column.
Any suggestions would be appreciated.