Formula to calculate average delivery time (days) on part#

.
Pics are nice but having a sample workbook is tons better. Please attach a workbook with the posted data included.

Thanks.

Hi Logit,

Have now added.

Thanks

.
Here is a macro version :

Please Login or Register  to view this content.

Hi boopathiraja,

thanks for taking the time to answer my question.
Can you please tell me how this formula is calculated?

Thanks in advance

Hi Logit,

Thanks for getting back to me.
How do I insert this macro into the workbook?

Thanks in advance

Thank you very much Logit!
That works great!

I have found that I need to add additional columns to the sheet.
Are you able to please reconfigure the macro to take these into consideration?

sheet attached.

Thanks in advance

.
The ranges are the only things that need to be edited. If you study the previous code and compare it to the code below (the range designations) you will see the difference.
The code below is already to go. You can remove the previous code and paste the below in its place or better yet, just use the attached workbook. It is already set up for
20,000 rows of data.

Please Login or Register  to view this content.

Thank you Logit

.
You are welcome.