terryg
01-26-2016, 09:38 AM
Hi,
I do not know VBA code and standard excel formulae cannot perform the following;
I have builders with different skill sets who work in different areas who can be assigned to any job at any address as long as it meets those 2 criteria.
Now I need a method of counting how many different addresses a builder is assigned to, it is complicated because they can have more than 1 job at an address but I want to count the addresses they have been assigned to.
this is further complicated by the fact that I only want to reckon with jobs that are in certain statuses.
please see attached sheets, contractors names are in sheet 'contractors' column B and I want the above result displayed in column I of that sheet.
jobs are recorded in sheet 'jobs' and their contractor is stored in column K.
Many thanks for help.
I do not know VBA code and standard excel formulae cannot perform the following;
I have builders with different skill sets who work in different areas who can be assigned to any job at any address as long as it meets those 2 criteria.
Now I need a method of counting how many different addresses a builder is assigned to, it is complicated because they can have more than 1 job at an address but I want to count the addresses they have been assigned to.
this is further complicated by the fact that I only want to reckon with jobs that are in certain statuses.
please see attached sheets, contractors names are in sheet 'contractors' column B and I want the above result displayed in column I of that sheet.
jobs are recorded in sheet 'jobs' and their contractor is stored in column K.
Many thanks for help.