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.