Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() I need to be able to count months in a filtered list I know this wont work but it will give you an idea of what I am trying to do. =MONTH(SUBTOTAL(3,AL12:AL10000)=5) Please help! A1 1 5/1/2017 2 8/15/2017 3 6/15/2017 4 6/15/2017 5 8/15/2017 6 6/15/2017 7 7/30/2017 8 8/15/2017 9 6/15/2017 10 5/2/2017 11 7/30/2017 12 6/15/2017 13 6/15/2017 14 6/15/2017 15 6/15/2017 Desired Output: After Filter Applied Jan 12 Feb 22 Mar 33 Apr 45 May 20 Jun 30 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting the number of unique values in a filtered list | Excel Discussion (Misc queries) | |||
Counting Months | Excel Worksheet Functions | |||
Counting unique text entries in a filtered list... | Excel Worksheet Functions | |||
Counting a Filtered List | Excel Discussion (Misc queries) | |||
Counting records in a filtered list | Excel Programming |