Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Measure on the date different
Hi,
I had a huge file of aroiund 10 000 line. This 10 000 line only consist of 500 items. I wish to have an analyise a information. Example in the file it have items, order date, recept date and qty. Item A order 3 time on 1 Jan but recept 1 time on 1 Feb and 2 time on 15 Feb. Item A order 2 time on 1 Feb but recept i time on 1 Mar and 1 time on 15 Mar etc for Item B...... Ans Item A 2 time take 30 days and 3 time 45 days. The numbers of days can be range 25 to 30 act as 30 and 40 to 50 can act as 45. etc for Item B ....... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Measure on the date different | Excel Worksheet Functions | |||
Measure on the date different | Excel Discussion (Misc queries) | |||
Units of measure | Excel Worksheet Functions | |||
Measure between date time A to date time B | Excel Discussion (Misc queries) | |||
I need to measure hours between two events(time/date) to give me . | Excel Worksheet Functions |