Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Auto Count for Auto Filter Doesn't Function under certain circumst

You can also use a function

=SUBTOTAL(3,A3:A500)&" of "&COUNTA(A3:A500)&" Records Found"



--

Regards,

Peo Sjoblom

"Jonathan Horvath" wrote in
message ...
going to answer my own question...

for a workaround check out:
http://support.microsoft.com/default...;EN-US;q213886

I found it after posting the question.

Jonathan



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
Count items with auto-filter Joe M. Excel Discussion (Misc queries) 1 June 12th 07 05:50 PM
Auto Number the Rows of Auto Filter Result ashish128 Excel Discussion (Misc queries) 3 April 29th 07 06:41 PM
Count Auto-filter results Gayla Excel Discussion (Misc queries) 1 March 7th 07 06:44 PM
Auto Filter function Wardy1 Excel Discussion (Misc queries) 2 March 30th 06 01:16 PM
Excel Auto Filter Function George Excel Worksheet Functions 5 March 17th 06 09:00 PM


All times are GMT +1. The time now is 12:52 AM.

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"