Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a number count of items on list after Filterings
I am using Excel 2003 to manage a Club list and would like an automatic
number count of the names on my list both before and after using various Filter functions. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a number count of items on list after Filterings
On Mon, 20 Mar 2006 15:16:28 -0800, Taylor
wrote: I am using Excel 2003 to manage a Club list and would like an automatic number count of the names on my list both before and after using various Filter functions. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions Before is just =COUNTA(A10:A20) After is =SUBTOTAL(2,A10:A20) where A10:A20 is the column range which includes all the rows of your data. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a number count of items on list after Filterings
I want Microsoft to make this feature automatic. If not then I will carry on
as I have. Place the number 1 in the top cell of a blank column of the list, point to the lower corner of that top cell to activate Autofill and hold down left mouse and drag the Autofill down the column to the end of the list. Sum the list and voila! Taylor "Taylor" wrote: I am using Excel 2003 to manage a Club list and would like an automatic number count of the names on my list both before and after using various Filter functions. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a number count of items on list after Filterings
Are you using the Autofilter? Not sure about XL2003, but XL2000 shows a
message in the status bar (lower left) showing the number of records found and Total number of records after performing a filter operation. "Taylor" wrote: I am using Excel 2003 to manage a Club list and would like an automatic number count of the names on my list both before and after using various Filter functions. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a number count of items on list after Filterings
=SUBTOTAL(function_num,ref1,ref2,...)
Refer to the help Subtotal works with filtered lists from the help file function_num can be the following 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARP In your case you need 2 for count Hope it helps George Taylor wrote: I am using Excel 2003 to manage a Club list and would like an automatic number count of the names on my list both before and after using various Filter functions. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a number count of items on list after Filterings
Select the range of interest. Run Data|List|Create List. This provides
the AutoFilter functionality automatically. Activate the Total row to obtain the automatic count you desire. Taylor wrote: I am using Excel 2003 to manage a Club list and would like an automatic number count of the names on my list both before and after using various Filter functions. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find next number in list | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Need to Count number of occurrences and get percentage of total | Excel Worksheet Functions | |||
Is the data validation criteria limited to a few number of items . | Excel Worksheet Functions | |||
Items in a List | Excel Discussion (Misc queries) |