Home |
Search |
Today's Posts |
#41
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count items in a filtered list?
On Thursday, July 21, 2005 at 7:10:09 PM UTC+2, N Harkawat wrote:
=subtotal(2,a1:a1000) "Counting filtered data." <Counting filtered wrote in message ... I have an excel spread sheet table that I filter. I would like to be able to count the number of cells in the filtered data. Anyone know how to do this? CountA returns the number of cells in the unfiltered data. Tom This worked for me, thanks! Simple easy solution. You can check in the help file for this function, you add "10" before the function code, in this case "2", thus input "102" to show only "visible" cells. Thus filtered or hidden cells are excluded from the count function. |
#42
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count items in a filtered list?
oand wrote:
On Thursday, July 21, 2005 at 7:10:09 PM UTC+2, N Harkawat wrote: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ This worked for me, thanks! Simple easy solution. [snip] Hello, Google Groupie. Thanks for replying to a post that is ***THIRTEEN ****ING YEARS OLD***. Yeah, I don't have a better use for my bandwidth, thanks. -- I could be wrong but that's never kept me from opening my mouth before. |
#43
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count items in a filtered list?
On Thursday, July 21, 2005 at 1:09:14 PM UTC-4, filtered Counting filtered data. wrote:
I have an excel spread sheet table that I filter. I would like to be able to count the number of cells in the filtered data. Anyone know how to do this? CountA returns the number of cells in the unfiltered data. Tom I could not get that to work. I am trying to count the number if names in a column. I would like to filter out some of the names based on gender or other characteristics. How do I do that? |
#44
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count items in a filtered list?
On Sunday, 7 July 2019 21:58:32 UTC+1, wrote:
On Thursday, July 21, 2005 at 1:09:14 PM UTC-4, filtered Counting filtered data. wrote: I have an excel spread sheet table that I filter. I would like to be able to count the number of cells in the filtered data. Anyone know how to do this? CountA returns the number of cells in the unfiltered data. Tom I could not get that to work. I am trying to count the number if names in a column. I would like to filter out some of the names based on gender or other characteristics. How do I do that? =SUBTOTAL(103,your_range) |
#45
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count items in a filtered list?
On Sunday, 7 July 2019 21:58:32 UTC+1, wrote:
On Thursday, July 21, 2005 at 1:09:14 PM UTC-4, filtered Counting filtered data. wrote: I have an excel spread sheet table that I filter. I would like to be able to count the number of cells in the filtered data. Anyone know how to do this? CountA returns the number of cells in the unfiltered data. Tom I could not get that to work. I am trying to count the number if names in a column. I would like to filter out some of the names based on gender or other characteristics. How do I do that? If you use subtotal(103, range:range), then i think that'll do it for you -- Notice: This email is confidential and may contain copyright material of members of the Ocado Group. Opinions and views expressed in this message may not necessarily reflect the opinions and views of the members of the Ocado Group. If you are not the intended recipient, please notify us immediately and delete all copies of this message. Please note that it is your responsibility to scan this message for viruses. References to the "Ocado Group" are to Ocado Group plc (registered in England and Wales with number 7098618) and its subsidiary undertakings (as that expression is defined in the Companies Act 2006) from time to time. The registered office of Ocado Group plc is Buildings One & Two, Trident Place, Mosquito Way, Hatfield, Hertfordshire, AL10 9UL. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Items in a List | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) |