Hi,
I have the attached workbook with 2x worksheets.
'Lead Times' sheet has each time a part was ordered for our inventory. Inculdes order date, part#, arrival date, total days.
This sheet displays the same part number multiple times to represent each time it was ordered.
'Average Lead Time' sheet shows my inventory with each part number only being displayed once.
I'm plesae requiring (preferrably V lookup if possible) a formula in column B of work sheet 'Average Lead Time' to find the number of orders via the part number in 'Lead Times' sheet, add then find the average amount of days for that part number to arrive.
Thanks very much in advance.
Bookmarks