Register
Log In
Unanswered
Home
March 16, 2017
Offline
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
See Answer
Dashboards
June 25, 2016
Offline
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
Answers Post
Most Users Ever Online: 57
Currently Online:
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Max Neumann
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
