Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
simple question on autofilter
hi,
my spreadsheet is: invoice_no product ======= ====== inv/1 orange inv/1 mango inv/1 banana inv/2 grapes inv/2 pineapple autofilter is turned on......... wat i would like is that when i select banana in product column, instead of all other rows disappearing and only inv/1 - banana being visible, i would like all inv/1 rows to also appear so if i select grapes instead of: inv/2 grapes it should come as: inv/2 grapes inv/2 pineapple the reason i need to do this is because each transaction of mine goes in multiple rows thanks. regards, shripal. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
simple question on autofilter
I am guessing you only have the product column autofiltered???
If so: 1) undue the autofilter you have 2) click in the cell that contains "invoice_no" (or any other cell in the same row) 3) now goto data and apply the autofilter 4) this will give you a filter drop down for each column. 5) now goto the invoice_no column and select "inv/1" 6) this will give you all products for "inv/1" 7) if you only want to see certain products click on the products filter and apply additional filters(you most likely will need the custom part of this filter. Garry "shripaldalal" wrote: hi, my spreadsheet is: invoice_no product ======= ====== inv/1 orange inv/1 mango inv/1 banana inv/2 grapes inv/2 pineapple autofilter is turned on......... wat i would like is that when i select banana in product column, instead of all other rows disappearing and only inv/1 - banana being visible, i would like all inv/1 rows to also appear so if i select grapes instead of: inv/2 grapes it should come as: inv/2 grapes inv/2 pineapple the reason i need to do this is because each transaction of mine goes in multiple rows thanks. regards, shripal. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Autofilter Question | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Autofilter Question | Excel Programming | |||
simple question, hopefully a simple answer! | Excel Programming |