is there a way for me to count that yes this is shown up a total of 69 times however, it with 14 unique dates? so it would spit out 14. ( note the data is large with mulitple numbers that need to be hit so if i do counta or countif or somthing like that i would have to adjust the formula month over month if that makes sense
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
formula/ pivot table
- Thread starter rawr19911
- Start date
-
- Tags
- piviot table
is there a way for me to count that yes this is shown up a total of 69 times however, it with 14 unique dates? so it would spit out 14. ( note the data is large with mulitple numbers that need to be hit so if i do counta or countif or somthing like that i would have to adjust the formula month over month if that makes sense
Excel Facts
Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
arthurbr
Well-known Member
- Joined
- Dec 8, 2006
- Messages
- 2,725
- Office Version
- 365
- Platform
- Windows
You can use Power Pivot to achieve that goal (solution #2)
Upvote
0
