pick out the lowest, avg, highest number in a range that meets criteria

Hello all

Got a question to ask and i would like to know if its possible to do or if i should look for a diffrent solution.

Problem:
Got a data sheet with diffrent products and i want to scan that list find all e.g "prod1"
among all the entries made regarding "prod1" i want to pick out the lowest, avg, highest number.

Prod1 :3
Prod3: 3
Prod1:8
Prod2:5
Prod1:4


Prod1 : 3 (lowest), 5(avg), 8 (highest).

These numbers will be stored on a diffrent sheet and if possible adjust the numbers when the data series grows.

Can it be done with any lookup/index magic?

Any hints/insight how i should procced are welcomed

Regards Zeroaim

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Can you amend your thread title Please.
Thank you.

Sorry for the swedish in the attached file.

but to explain what i want to do.

Under the ribbon "frollic" u find 3 buttons (only "inmatning" is working atm. adding more info to the data sheet)
2nd button i would like to do this ->
Look through the data and find all products with the same name.
among them find the lowest time and add that to the "ss" sheet at the correct product name.
same goes for the "avg" and "longest" times.
With more entries into the data sheet is should also "update" when a new time is added. could use a "refresh" button on SS for that thou.

Hope it clears some questions. dont want to hit u all with wall of text here

Will this be doable? or should i look for some other way around it.

Regards Zeroaim