Prev Previous Post   Next Post Next
  #1   Report Post  
bronsonbits
 
Posts: n/a
Default excel filtering

Gary,
I've tried this, but the number also includes my criteria range, (in my
case, always 4 extra records). How do I eliminate the criteria range from the
count?



"Gary Brown" wrote:

Lower left hand corner of screen will say something like...
'25 of 187 records found' immediately after applying the filter
HTH,
Gary Brown
using Excel XP


"Arthur Kuijper" wrote:

how can I see how many rows meet my filter criteria in excel

 
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM
Filtering Rows in Excel? Peter W Excel Discussion (Misc queries) 2 December 24th 04 01:09 AM
Filtering data in Excel for mailmerge to Word Jane Shaffer Excel Discussion (Misc queries) 1 November 28th 04 06:05 PM


All times are GMT +1. The time now is 08:54 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"