Assumptions:
1) A1:B7 contains your data
2) Column D contiains your unique values, such as GGDA06C280.00, etc.
For minimum...
E1, copied down:
=MIN(IF($A$1:$A$7=D1,$B$1:$B$7))
....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.
For maximum...
F1, copied down:
=MAX(IF($A$1:$A$7=D1,$B$1:$B$7))
....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.
Hope this helps!
In article ,
"carl" wrote:
I have a large data table that is set up like this:
GOUL05C260.00 34.8
GGDL05C320.00 9.3
YVCM08P310.00 64.8
YVCM08P310.00 65.8
YVCA08C320.00 57.1
YVCA08C320.00 58.1
OQDM07P500.00 218.6
I am trying to set up a table that will look at colA above and find the min
and max values from colb
The table could be like this:
Min Max
GGDA06C280.00
GGDA06C290.00
GGDA06C300.00
GGDA06C310.00
GGDA06C320.00
Thank you in advance.
|