Excel Question

[Groves22]

I wasn't quite sure where to ask this... so if it's not in the correct place, I'm sorry.

I am trying to find the minimum number of a group of numbers, with several different gourps.

It might be easier with an example:

Key Number
ACPA20096 74
ACPA20096 74
ACPA20127 56
ACPA20127 23
ACPA20127 56
ACPA20127 56
ACPA20176 53
ACPA20176 61
ACPA20176 53
ACPA20177 32
ACPA20177 41

I am trying to get the min number for each unique key. So ACPA20096 = 74, ACPA20127 = 23, etc.

How would I do something like that? I have over 15000 rows, and I don't want to do it row by row!
Thanks!

 

[SkipVought]

Hi,

No need for VBA. Use the PivotTable wizard as select the Min aggregator in the DATA area for your Number field.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

You may also use the Data -> SubTotal tool.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Groves22]

Thanks Skip! You helped me again today!
I need to become more familiar with PivotTables!