Forum Discussion
Counting unique records with multiple condition in excel
Hi Experts, Seeking advise on how to find unique count of records using date and multiple conditions. My Raw data is below: Date Name Dept Location Status 2024-02-01 King Finance Cana...
=LET(filtered,
UNIQUE(FILTER(HSTACK(C2:C23,B2:B23),(A2:A23>=H3)*(A2:A23<=H4)*(E2:E23=H5))),
count,
DROP(REDUCE("",SEQUENCE(ROWS(filtered)),LAMBDA(u,v,VSTACK(u,HSTACK(INDEX(filtered,v,),SUM(N((INDEX(filtered,,1)=INDEX(filtered,v,1)))))))),1),
IFERROR(UNIQUE(CHOOSECOLS(count,1,3)),"no matching data"))
With Office 365 or Excel for the web this formula returns the expected result in my sample file.
- Thanks a ton!! This is working perfectly fine !
