itsgrady
Board Regular
- Joined
- Sep 11, 2022
- Messages
- 115
- Office Version
- 2021
- Platform
- Windows
- MacOS
I can get Excel to use the UNIQUE Formula for a column in a Table, but I am not able to do a subtotal formula using the UNIQUE Formula.
This formula is given a subtotal COUNTA of the entire column: Returns 1034
=SUBTOTAL(3,Table1[PType])
But I need a subtotal of the Unique CountA of the table column.
=SUBTOTAL(3,UNIQUE(Table1[PType])). Should return 8, but it not allowing the formula.
This formula is given a subtotal COUNTA of the entire column: Returns 1034
=SUBTOTAL(3,Table1[PType])
But I need a subtotal of the Unique CountA of the table column.
=SUBTOTAL(3,UNIQUE(Table1[PType])). Should return 8, but it not allowing the formula.