G
Guest
Please see example below:
Fiscal Year Lead Time (Days)
======================
FY05 11
FY05 23
FY05 16
FY06 14
FY06 21
FY06 35
FY07 8
FY07 26
FY07 33
======================
I need a formula that will allow me to count the # of records above that are
(for example) in FY05 and fall between 10 and 20 days. The answer should be
(2).
Thanks in advance for you help.
Dellbad
Fiscal Year Lead Time (Days)
======================
FY05 11
FY05 23
FY05 16
FY06 14
FY06 21
FY06 35
FY07 8
FY07 26
FY07 33
======================
I need a formula that will allow me to count the # of records above that are
(for example) in FY05 and fall between 10 and 20 days. The answer should be
(2).
Thanks in advance for you help.
Dellbad