Filter mode

[Leslie Isaacs]

Hello All

I am using excel 2000.

I have a fairly large spreadsheet (27,000 rows, 11 columns), and have used
the auto-filter function which works fine - except:
how do I get a display of the "xxxx of xxxx records found" information where
it says "filter mode" bottom left (just above the task bar)? If I
right-click on "filter mode" I can select 'none', 'average', 'count', 'count
nums', 'max', 'min' or 'sum' - but on doing so nothing seems to happen! What
should happen?

I have seen the "xxxx of xxxx records found" information on other
spreadsheets so I know it is possible, but I cannot find any option to
activate/display this.

I would be very grateful for any help.

Many thanks,
Leslie Isaacs

 

[Norman Jones]

Hi Leslie,

See Debra Dalgleish's Status Bar Record Count notes at:

http://www.contextures.com/xlautofilter02.html#Count

 

[Leslie Isaacs]

Norman

Many thanks - great info!

Les

Hi Leslie,

See Debra Dalgleish's Status Bar Record Count notes at:

http://www.contextures.com/xlautofilter02.html#Count