tezza
Active Member
- Joined
- Sep 10, 2006
- Messages
- 384
- Office Version
- 2016
- 2010
- Platform
- Windows
- Web
HI All
Hope you can help.
I've got this formula below in a spreadsheet:
How do I update this to count the visible unique values in the same range?
I've tried what I figured to be a logical solution (as 103 = counta) but it just throws up an error:
Regards
Tez
edit: 365 version
Hope you can help.
I've got this formula below in a spreadsheet:
Excel Formula:
=COUNTA(UNIQUE($M$2:$M$10231))
How do I update this to count the visible unique values in the same range?
I've tried what I figured to be a logical solution (as 103 = counta) but it just throws up an error:
Excel Formula:
=subtotal(103,UNIQUE($M$2:$M$10231))
Regards
Tez
edit: 365 version