Forum Discussion
Solved
Trying to count text using a date as reference
Need help to count the number of items based on a date. my dates 01-Dec through to 25-dec are in column c. the items i need to count are in columns d through to ac there are 9 possible types of item...
- Brilliant 🙂
Only problem my mac doesn't support slicers 🙂 but really thank you much appreciated
rgds
If you provide small sample file and mention on which Excel version / platform you are, we may try to play with formulas for your case.
Hi Sergei
Much appreciated
File attached, i'm trying to build the table on the Orders Tab, from the test date on the form response tab.
- forgot to add using 2011 on a mac
- Hi received this mail..below but can't trace where the results are, sorry for being dense
..mail begin..
Hi
Microsoft Tech Community <MicrosoftTechCommunity@us.khoros-mail.com>
Mon 04/10/2021 06:34
Here's the main Pivot View:
with the formula count below it, and other pivot views above and below it.:
cheers
mail end....I removed it because my solution is not based on mac but here take a look see if you can work it out
