Hi, I have a spreadsheet with the following type of information but is 2000 rows:
<colgroup><col span="3"></colgroup><tbody>
</tbody>
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.
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 |
<colgroup><col span="3"></colgroup><tbody>
</tbody>
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.