I have an excel file, merged from two files...one with individua
receipt date and quantity and another with total physical quantity o
hand as follows:

sr.no Id Date Rect qty Phy qty
107140 TS68A 08/16/2003 8 32
107140 TS68A 08/16/2003 8 32
129964 TS68A 02/23/2004 12 32
129964 TS68A 02/23/2004 12 32
142133 TS68A 05/26/2004 12 32
142133 TS68A 05/26/2004 12 32
145389 TS68A 06/20/2004 14 32

Phy. qty is the quantity on hand as of TODAY hence it is not changin
with each receipt. There are around 5000 Ids.

I need to age the 32 quantity that is lying in stock as follows
<2 month <4 months 4 months+
TS68A 14 18 0

regards,
edward

--
Message posted from http://www.ExcelForum.com