Min and Max
 

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.

A Pivot Table will give you the report that you want. The table format
chooser will allow you to format the table as you want it.
--
Gary's Student


"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.

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.