chandrashekar
Well-known Member
- Joined
- Jul 15, 2005
- Messages
- 524
- Office Version
- 365
- Platform
- Windows
Hello,
am trying below formula to get unique count based on multi criteria but am getting wrong count.
Can you please let me know where is error.
=IFERROR(ROWS(UNIQUE(FILTER(Sheet1!M2:M59039,(Sheet1!B2:B59039<>"HD")*(Sheet1!AH2:AH59039=1)*(Sheet1!AM2:AM59039="CH")*IFERROR(Sheet1!AL2:AL59039="First",0)+IFERROR(Sheet1!AL2:AL59039="Second",0)+IFERROR(Sheet1!AL2:AL59039="Three",0)))),0)
Regards,
Chandrashekar B
am trying below formula to get unique count based on multi criteria but am getting wrong count.
Can you please let me know where is error.
=IFERROR(ROWS(UNIQUE(FILTER(Sheet1!M2:M59039,(Sheet1!B2:B59039<>"HD")*(Sheet1!AH2:AH59039=1)*(Sheet1!AM2:AM59039="CH")*IFERROR(Sheet1!AL2:AL59039="First",0)+IFERROR(Sheet1!AL2:AL59039="Second",0)+IFERROR(Sheet1!AL2:AL59039="Three",0)))),0)
Regards,
Chandrashekar B