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.