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. |
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. |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com