PDA

View Full Version : Find the max and min from a range of cell given a criteria



jtech
04-26-2013, 09:54 PM
:( 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
04-27-2013, 12:50 AM
attach please a sample file with desired result

jtech
04-27-2013, 05:19 AM
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
04-27-2013, 07:35 AM
I mean xls file not image

jtech
04-27-2013, 08:58 AM
Sorry, I dont have the code yet I dont know how to acomplish this task
in vba.