B
Bob Beard
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.
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.