Posted to microsoft.public.excel.programming

Dean[_4_]

external usenet poster

Posts: 8

Filtered Count

Hi,

I have an always changing list. This list is filtered to only show
what I want, how can I count the filtered list.

I've done a count of the range but it still counts everything, I only
want what is still visible.
Currently I have the list being copied to another sheet, counted and
the count being pasted back to the list sheet but this is time
consuming.

Thanks
Dean

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 all except filtered data	andy62	Excel Discussion (Misc queries)	2	May 12th 09 07:43 PM
Count the Y's in a filtered column that contains Y and N	TommyB	Excel Worksheet Functions	1	July 11th 08 02:43 AM
count if on Visible - Filtered	tonyv	Excel Worksheet Functions	4	July 7th 07 07:34 PM
count filtered data	ccravens	Excel Discussion (Misc queries)	1	March 23rd 07 12:08 AM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row	Sam via OfficeKB.com	Excel Worksheet Functions	9	July 31st 05 03:37 AM

All times are GMT +1. The time now is 02:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us