creative999
Board Regular
- Joined
- Jul 7, 2021
- Messages
- 85
- Office Version
- 365
- 2019
- Platform
- Windows
- MacOS
Im using the formulas below to count unique values. However, just realised need to do a count based on case. Any suggestions on how i can tweak the formulas below?
=SUMPRODUCT((('SHEET1'!E3:E$5000<>"")/COUNTIF('SHEET1'!E3:E$5000,'SHEET1'!E3:E$5000&"")))
=IFERROR(SUM(--(LEN(UNIQUE(FILTER('SHEET1'!E3:E$5000, 'SHEET1'!G3:G$5000=TRUE)))>0)),0)
=IFERROR(SUM(--(LEN(UNIQUE(FILTER('SHEET1'!E3:E$5000,('SHEET1'!!H3:H$5000="AC")*('SHEET1'!!G3:G$5000=TRUE))))>0)),0)
=SUMPRODUCT((('SHEET1'!E3:E$5000<>"")/COUNTIF('SHEET1'!E3:E$5000,'SHEET1'!E3:E$5000&"")))
=IFERROR(SUM(--(LEN(UNIQUE(FILTER('SHEET1'!E3:E$5000, 'SHEET1'!G3:G$5000=TRUE)))>0)),0)
=IFERROR(SUM(--(LEN(UNIQUE(FILTER('SHEET1'!E3:E$5000,('SHEET1'!!H3:H$5000="AC")*('SHEET1'!!G3:G$5000=TRUE))))>0)),0)