Identifying the Lowest grade for a student

Hi Folks,
Need some help.
I have a list

[Column 1 Col2 Col3
JOHN 5 2
JOHN 10 2
JOHN 2 2
JOHN 20 2
JAMES 28 4
JAMES 4 4
JAMES 18 4
JULIE 5 0
JULIE 6 0
JULIE 0 0
JULIE 3 0
I want the lowest figure for each person to appear in the third coulmn (I have the data in the first two columns)

I would use a formula like the one below - to count the number of instances the individual's name appears
COUNTIF($D$6:$D$17727,$D$6:$D$17727)

Is there something similar that will let me produce the lowest number in the 3rd column ?
Thank You

With your sample data in A2:B12
This regular formula, copied down, returns lowest score for the referenced name

Please Login or Register  to view this content.

Is that something you can work with?

Name Figure Lowest
John 5 2
John 10 2
John 2 2
John 20 2
James 28 4
James 4 4
james 18 4
Julie 5 0
Julie 6 0
Julie 0 0
Julie 3 0


This is how I want it to appear. The data must appear in the 3rd column
Thus, the lowest figure for John is 2, James is 4 and Julie is 0.
But i need a formula for that
I tried using the formula but i didn't get it.
Thank you

Here you go:

Please Login or Register  to view this content.

Here's another one.

For the minimum...

Data Range

	A	B	C
1	Name	Value	Minimum
2	JOHN	5	2
3	JOHN	10	2
4	JOHN	2	2
5	JOHN	20	2
6	JAMES	28	4
7	JAMES	4	4
8	JAMES	18	4
9	JULIE	5	0
10	JULIE	6	0
11	JULIE	0	0
12	JULIE	3	0

This array formula** entered in C2 and copied down:

=MIN(IF(A$2:A$12=A2,B$2:B$12))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

For the maximum value just replace MIN with MAX:

=MAX(IF(A$2:A$12=A2,B$2:B$12))

You're welcome. We appreciate the feedback!