View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Youssef B. Youssef B. is offline
external usenet poster
 
Posts: 1
Default Filtering columns independently

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.