J
Johnny
I've scanned through related posts with no luck. I have a production
spreadsheet with several columns of data. Here are the relevant columns (3)
for my question:
City Employee Date
I need to count the distinct number of employees based on the city and a
date range. Let's say that the date range is 1/1/09 to 1/31/09 and is in
cells A1 and A2 respectively.
Cities and Employees are duplicated multiple times. What I want to end up
with is the count of the number of emloyees for a particular City for a
given date range.
spreadsheet with several columns of data. Here are the relevant columns (3)
for my question:
City Employee Date
I need to count the distinct number of employees based on the city and a
date range. Let's say that the date range is 1/1/09 to 1/31/09 and is in
cells A1 and A2 respectively.
Cities and Employees are duplicated multiple times. What I want to end up
with is the count of the number of emloyees for a particular City for a
given date range.