Subtotal and Unique

[itsgrady]

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.

 

[Fluff]

How about

=ROWS(UNIQUE(FILTER(Table1[PType],SUBTOTAL(3,OFFSET(Table1[[#Headers],[PType]],SEQUENCE(ROWS(Table1[PType])),0))=1)))

 

[itsgrady]

How about

=ROWS(UNIQUE(FILTER(Table1[PType],SUBTOTAL(3,OFFSET(Table1[[#Headers],[PType]],SEQUENCE(ROWS(Table1[PType])),0))=1)))

Thanks!!! I appreciate the help! I would have never guessed or been able to worked this out without your help. Have a great day.

 

[Fluff]

You're welcome & thanks for the feedback.