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:
DateNameDeptLocationStatus2024-02-01KingFinanceCanadaInactive2024-02-01DianaSalesCanadaActive2024-02-01HarrySalesUSAActive2024-02-01StuartSalesUSAActive2024-02-01BettySalesCanadaActive2024-02-01EvanFinanceUKActive2024-02-01SteveFinanceUKActive2024-03-01KingFinanceCanadaInactive2024-03-01HarrySalesUSAActive2024-03-01StuartSalesUSAActive2024-03-01EdwinFinanceUKActive2024-03-01LauraHRCanadaActive2024-04-01HarrySalesUSAActive2024-04-01StuartSalesUSAActive2024-04-01LarryHRUSAActive2024-04-01LauraHRCanadaActive2024-05-01HarrySalesUSAActive2024-05-01ThomasSalesUSAActive2024-05-01StuartSalesUSAActive2024-05-01LarryHRUSAActive2024-05-01LauraHRCanadaActive2024-05-01BettySalesCanadaActive
My output which I am expecting is below.
My output which I am expecting is below.
The user shall enter the From and To dates and the Status=Active/Inactive. The output should be the count of active distinct employees during that period by Department.
Appreciate your help in advance.
Regards,
PPG
Hi Experts,Seeking advise on how to find unique count of records using date and multiple conditions.My Raw data is below:DateNameDeptLocationStatus2024-02-01KingFinanceCanadaInactive2024-02-01DianaSalesCanadaActive2024-02-01HarrySalesUSAActive2024-02-01StuartSalesUSAActive2024-02-01BettySalesCanadaActive2024-02-01EvanFinanceUKActive2024-02-01SteveFinanceUKActive2024-03-01KingFinanceCanadaInactive2024-03-01HarrySalesUSAActive2024-03-01StuartSalesUSAActive2024-03-01EdwinFinanceUKActive2024-03-01LauraHRCanadaActive2024-04-01HarrySalesUSAActive2024-04-01StuartSalesUSAActive2024-04-01LarryHRUSAActive2024-04-01LauraHRCanadaActive2024-05-01HarrySalesUSAActive2024-05-01ThomasSalesUSAActive2024-05-01StuartSalesUSAActive2024-05-01LarryHRUSAActive2024-05-01LauraHRCanadaActive2024-05-01BettySalesCanadaActive My output which I am expecting is below.My output which I am expecting is below.The user shall enter the From and To dates and the Status=Active/Inactive. The output should be the count of active distinct employees during that period by Department. Appreciate your help in advance. Regards,PPG Read More
