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.