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
Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
arthurbr
Well-known Member
- Joined
- Dec 8, 2006
- Messages
- 2,775
- Office Version
- 365
- Platform
- Windows
You can use Power Pivot to achieve that goal (solution #2)
Upvote
0
