Excel: Fomrula for unique records between 2 dates


Hi, I have a spreadsheet with the following type of information but is 2000 rows:

Customer Date Lead Time
A 01/01/2014 1
A 04/01/2014 3
B 05/01/2014 1
C 04/02/2014 3
A 05/02/2014 5
I would like a formula to return number of customers including and between 1/1/14 and 31/1/14 so would expect the result 2 for the sample above. Also I would like return min lead time for the same time period so would expect this to return 1. Ive been racking my brain for days and trying lots of examples but keep failing so any help is greatly appreciated. Thanks.


This question generated 16 answers. To proceed to the answers, click here.

This thread is current as of November 23, 2014.


For more resources for Microsoft Excel