Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED

The filter function does not indicate number of records selected in the
bottom left-hand corner (i.e. 29 of 100 records). It simply reads "Filter
Mode." I don't know if the file is corrupted. Excel has been re-installed.
I don't have this problem with other spreadsheets that are sent to me.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED

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


--


Regards,


Peo Sjoblom


"MUSANDAI" wrote in message
...
The filter function does not indicate number of records selected in the
bottom left-hand corner (i.e. 29 of 100 records). It simply reads "Filter
Mode." I don't know if the file is corrupted. Excel has been
re-installed.
I don't have this problem with other spreadsheets that are sent to me.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED

See

http://support.microsoft.com/kb/213886/en-us

In article ,
MUSANDAI wrote:

The filter function does not indicate number of records selected in the
bottom left-hand corner (i.e. 29 of 100 records). It simply reads "Filter
Mode." I don't know if the file is corrupted. Excel has been re-installed.
I don't have this problem with other spreadsheets that are sent to me.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
show number of selected records in Excel Jonathan Dore Excel Discussion (Misc queries) 6 May 10th 07 03:01 PM
Print Pivottable - show all selected items in page filter Koen Excel Discussion (Misc queries) 0 June 19th 06 09:30 AM
Using Excel's Auto Filter, how can I show # of records returned? Jim Excel Worksheet Functions 1 March 13th 06 07:39 PM
How do I obtain total for auto filter value selected ? FLo Excel Discussion (Misc queries) 1 November 22nd 05 03:08 PM
How do I show number of records that meet criteria filter CliffD Excel Discussion (Misc queries) 3 August 22nd 05 01:10 PM


All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"