Need formula to find top 3 value from large number of data

[emran06]

Dear Experts,
I am facing problem to make summary sheet of top 3 value from large number of value of my excel sheet like-
Sheet1

A Group	B Name	C Value
1	Nashid	200145
2	Kashem	188516
1	Jabed	184198
2	Rubel	172569
3	Romel	168251
1	Eman	156622
2	Hasin	152304
3	Nasim	136357
3	Hasan	120410
2	Monem	104463
1	Rashed	88516
3	Nizam	72569

<tbody>
</tbody>

Now I want to make summary in sheet2 top 5 value among the list of sheet1 separately from group 1, 2 & 3.
If group number is 1 in sheet1 then top 3 value will be like this-
Group1

Name	Value
Nashid	200145
Jabed	184198
Eman	156622

<tbody>
</tbody>

If group number is 2 in sheet1 then top 3 value will be like this-
Group2

Name	Value
Rubel	172569
Hasin	152304
Monem	104463

<tbody>
</tbody>

If group number is 3 in sheet1 then top 3 value will be like this-

Name	Value
Romel	168251
Nasim	136357
Hasan	120410

<tbody>
</tbody>

Please help me if anyone know the formula. Thank you in advance for your help.

Best Regards

Emran

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/excel-questions/772342-help-formula-find-top-3-value-excel.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).