Home » Forums » Open Source Learning Center » Question and Answer

Filter HideArrows and Subtotals

Submitted by macclane on 8 March, 2010 - 22:51

Hello everyone,

I want to do a couple things to this excel sheet. First I want the user only to be able to filter the Product column and the Description Column but not the rest of them. What is the query for this?

Secondly and most importantly, If you select all products it give a Total amount at the bottom. But I want to be able to when I filter a product (example Cheese)  that it displays a Subtotal in the Total field rather than it still showing the Total. But when I select all products again it displays the Total. Can this be done? Hope this makes sense?!?

 

Thanks,

Doug

AttachmentSize
excelpros example.xls26 KB
‹ The Protect feature VBA function to get the address of a range ›
»
Vishesh's picture

Use subtotal function

Submitted by Vishesh on 9 March, 2010 - 16:00.

=SUBTOTAL(109,A2:A5)
109 means it will ignore hidden rows, A2:A5 - change it as per your own requirement

»

Thanks! One last thing, I

Submitted by macclane on 9 March, 2010 - 17:01.

Thanks!

One last thing, I want to be able to hide the filters for all the columns except Product and Description. Can you help me?

»
Vishesh's picture

Filter Hide Arrows

Submitted by Vishesh on 10 March, 2010 - 15:21.

Check this link...

 http://excelexperts.com/node/893

It was submitted sometime back by Nick. With some minor changes as per you requirement it should solve your problem.

»