E
excelFan
hi all, please help
A B
--------- ----------
date item
--------- ----------
02/14/04 azm
07/22/05 naf
11/21/05 naf
03/26/06 naf
04/18/07 naf
04/20/07 azm
05/19/07 azm
06/08/07 ktm
08/22/07 ktm
i like to find the number of days between max and min dates for a given item
in column B
A B
--------- ----------
date item
--------- ----------
02/14/04 azm
07/22/05 naf
11/21/05 naf
03/26/06 naf
04/18/07 naf
04/20/07 azm
05/19/07 azm
06/08/07 ktm
08/22/07 ktm
i like to find the number of days between max and min dates for a given item
in column B