Drop Down Filter
 

Hi,

I have data that I input in from Column A to F [cells 1-
50]. In column G I have the total of these rows.

How can I produce a custom filter on column G that works
from a drop down that will show 3 things - <500, 500-999
and more than 999?

The cells with numbers not required will remain there but
will not show any value.

I can do it via custom filter but have to set it every
time and it does not allow more than 2 filters.

Thanks as usual,

Bob.

You could insert another column into the table. For example, in cell H1,
enter the heading: Group
In cell H2, enter the formula:
=IF(G2<500,"<500",IF(G2<=999,"500-999","999"))
Copy the formula down to row 50
Filter on column H

Bob Beard wrote:
Hi,

I have data that I input in from Column A to F [cells 1-
50]. In column G I have the total of these rows.

How can I produce a custom filter on column G that works
from a drop down that will show 3 things - <500, 500-999
and more than 999?

The cells with numbers not required will remain there but
will not show any value.

I can do it via custom filter but have to set it every
time and it does not allow more than 2 filters.

Thanks as usual,

Bob.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html