Thanks. The "max" setting is what I was missing.

"Bernie Deitrick" wrote:

That is a perfect use of a pivot table: Company in the row field, Group in the row field, Value in
the data field, set to MAX.
-
HTH,
Bernie
MS Excel MVP


"dj479794" wrote in message
...
Excel 2003

I need a formula that will tell me the largest number in the "Value" column
for a specific "Group".

In the sample data below the value for ACME's "USA" group would be "1.5" for
their "UK" Group it would be "0.5"
"DJ INDUSTRIES "Alpha" group it would be "1.0".

Some "Group" Names maybe the same for diffferent companies ("Company"). So
the formula needs to identify a change in "company" value as well.

Example of Data:
"/" = Denotes New Column of Data
First Row are Column Headers

Company / Group / Product Code / Value / {Column for formula}
ACME/USA/3456/0.5
ACME/USA/3456/0.5
ACME/USA/5432/1.0
ACME/USA/9584/1.5
ACME/UK/3456/0.5
ACME/UK/3456/0.5
DJ INDUSTRIES/ALPHA/5432/1.0
DJ INDUSTRIES/ALPHA/3456/0.5
JR ENTERPRISES/34RES/9584/1.5


Thanks!