Notifications
Clear all
Topic starter
Hi,
I have a excel database that I would like to implement a count function that counts the number of engineers per site based on the site selected by the user and exclude duplicates.
The user selects the site from the drop down list cell D3.
Column D8:D1000 has a list of multiple sites and column J8:J1000 has the list of multiple engineers per site.
Attached is a copy of the database.
Kind regards,
Craig
Posted : 18/05/2017 5:56 am
Hi Craig
Give this a try.
In cell E3 of the Gas Safety Audits worksheet, array-enter (enter with CTRL+SHIFT+ENTER) the formula below
=SUM(IF(D3=D8:D1000,1/(COUNTIFS(D8:D1000,D3,J8:J1000,J8:J1000)),0))
Hope this helps
Sunny
Posted : 18/05/2017 11:19 am
Topic starter
Thanks Sunny,
Your suggestion work perfectly
Kind regards,
Craig
Posted : 19/05/2017 5:38 am
