Return Less value based on Duplicate names

[harinsh]

Hello,

I am looking for excel function to return less value in Duplicate names given below. Ex. if we take AAA has three duplicates with different values however, I need less value out of all the duplicates and should be return the less value as output, in this case value 100.00 should get as output in column 'C'
[TABLE="width: 128"]
<tbody>[TR]
[TD]
Input data:

Names
[/TD]
[TD]


Values
[/TD]
[/TR]
[TR]
[TD]AAA
[/TD]
[TD]100.00
[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]200.00
[/TD]
[/TR]
[TR]
[TD]CCC[/TD]
[TD]300.00
[/TD]
[/TR]
[TR]
[TD]DDD[/TD]
[TD]100.00
[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]240.00
[/TD]
[/TR]
[TR]
[TD]CCC[/TD]
[TD]350.00
[/TD]
[/TR]
[TR]
[TD]FFF[/TD]
[TD]110.00
[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]250.00
[/TD]
[/TR]
[TR]
[TD]FFF[/TD]
[TD]100.00
[/TD]
[/TR]
</tbody>[/TABLE]

Output data:
Names Values Result
AAA 100.00 100
BBB 200.00 na
CCC 300.00 300
DDD 100.00 na
AAA 240.00 100
CCC 350.00 300
FFF 110.00 100
AAA 250.00 100
FFF 100.00 100

 

[sheetspread]

Excel 2010
	A	B	C
1	Names	Values
2	AAA	100
3	BBB	200
4	CCC	300
5	DDD	100
6	AAA	240
7	CCC	350
8	FFF	110
9	AAA	250
10	FFF	100
11
12	Names	Values	Result
13	AAA	100	100
14	BBB	200	na
15	CCC	300	300
16	DDD	100	na
17	AAA	240	100
18	CCC	350	300
19	FFF	110	100
20	AAA	250	100
21	FFF	100	100
Sheet18

Cell Formulas
Range	Formula
C13	{=IF(COUNTIF($A$2:$A$10,A13)=1,"na",MIN(IF($A$2:$A$10=A13,$B$2:$B$10)))}
Press CTRL+SHIFT+ENTER to enter array formulas.