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.