Min and Max

[Guest]

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.

 

[Guest]

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.

 

[Domenic]

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!