fb7894
07-25-2013, 03:34 PM
Hello. I am trying to formulate the following problem.
I am looking to calculate the average Number of Resources (col D), for each DISTINCT Deal ID (col A) where the start date < Jan-10 and the end date > Jan-10.
Any suggestions?
The answer in this case should be 2.5. Because Deal #1 is a duplicate, I only want to include 1 row in the average. Thank you!
I am looking to calculate the average Number of Resources (col D), for each DISTINCT Deal ID (col A) where the start date < Jan-10 and the end date > Jan-10.
Any suggestions?
The answer in this case should be 2.5. Because Deal #1 is a duplicate, I only want to include 1 row in the average. Thank you!