Max and min values

**LiLi1** · 01-14-2010, 02:34 PM

I have a list of names in one column next to those names are yearly entries for amount of days a project took (see first list for example with zero being the project was finished on the day given).
There are about ~1000 entries in that list.
I have a third and fourth and fifth columns ( see second example) set up where I am trying to look through all the yearly entries of days that projects took for each person (from columns one and two) and total the min and max amount of days for each person (~60 people). I have tried a few functions but nothing is returning the data I want. Any ideas?

2 brian
3 kelly
1 natalie
0 george
3 brian
0 brian
2 kelly
1 george
15 scott
2 scott

brian max# min#
kelly max# min#
george max# min#
natalie max# min#
scott max# min#

**zbor** · 01-14-2010, 02:40 PM

Here, try this next to names: =MAX(IF($B$1:$B$10=$B14,$A$1:$A$10))

comfirm with ctrl+shift +enter

And pull down... same for MIN just change to MIN

Adjust range

**NBVC** · 01-14-2010, 02:41 PM

Use a pivot table..

Drag name to Row area.

Drag numbers to Data area, twice.

Change Field Setting for one column to Min, the other to Max.

Using Pivot Tables: http://peltiertech.com/Excel/Pivots/pivotstart.htm

**LiLi1** · 01-14-2010, 03:32 PM

Thanks! for the awesome and quick responses.
I had played around with a pivot table already with the data so I went with that solution and it worked perfectly.