Help Please-Counting Filtered Rows
Please post response as email is bogus to prevent spam.
I am using Excel 2003. I admit I lost my note on this and appreciate how to do this. I am filtering data. The original list is say 500 rows. When I filter on measure I see only what I want, but I want to insert a formula that tells me ONLY how many rows are showing up on that filtering. Thanks in advance for any help. baz |
Help Please-Counting Filtered Rows
Look in help for SUBTOTAL
=SUBTOTAL(3,range) will count visible text and number values, equivalent to COUNTA 2 is the equivalent to COUNT -- Regards, Peo Sjoblom "baz" wrote in message ... Please post response as email is bogus to prevent spam. I am using Excel 2003. I admit I lost my note on this and appreciate how to do this. I am filtering data. The original list is say 500 rows. When I filter on measure I see only what I want, but I want to insert a formula that tells me ONLY how many rows are showing up on that filtering. Thanks in advance for any help. baz |
Help Please-Counting Filtered Rows
I think my feeble brain recalled how to do it - Subtotal, condition 3
Thanks for any other thoughts. baz On Fri, 16 Dec 2005 17:48:02 GMT, (baz) wrote: Please post response as email is bogus to prevent spam. I am using Excel 2003. I admit I lost my note on this and appreciate how to do this. I am filtering data. The original list is say 500 rows. When I filter on measure I see only what I want, but I want to insert a formula that tells me ONLY how many rows are showing up on that filtering. Thanks in advance for any help. baz |
All times are GMT +1. The time now is 06:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com