Find the max and min from a range of cell given a criteria

[jtech]

Hi, Iam new to this forum. Iam trying to find the max and Min value in a
range of cells that has a certain criteria. For example, I have column a
tha shows different types of mesurement
a = voltage, curent, watts, resistance, ect.
now if I choose "curent" I would like the macro to show me the max and min
values for that criteria.

[patel]

attach please a sample file with desired result

[jtech]

Thanks for replying, here is what a want to do,
I want to take column B and find the Stages, for example Stage A
and then find the Max and Min For that stage.
I would like to do this with VBA code not with formulas

[patel]

I mean xls file not image

[jtech]

Sorry, I dont have the code yet I dont know how to acomplish this task
in vba.