Help for formula to find Top 3 value in excel

[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

Group	Name	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

 

[Ingolf]

check the below formula
=INDEX(Sheet1!$B$2:$C$13,MATCH(LARGE(($B$1=Sheet1!$A$2:$A$13)*(Sheet1!$C$2:$C$13),COUNTA($A$3:$A3)),Sheet1!$C$2:$C$13,0),MATCH(A$3,Sheet1!$B$1:$C$1,0))

And this formula result will be incorrect.
If column C have the same value for two different people, but the same group, formula returns a false result.

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

<colgroup><col width="64" style="width: 48pt;" span="3"> <tbody> </tbody>

and result will be:

Group	2
Name	Value
Kashem	188516
Rubel	172569
Rubel	172569

<colgroup><col width="64" style="width: 48pt;" span="2"> <tbody> </tbody>

 

[Peter_SSs]

I have not noticed already PeterSS said the same thing.

As well as me raising this issue (on at least 3 occasions I think), perhaps you had also missed this from the OP?

In my data sheet there is no two people from the same group and same value.

If correct, it obviates the need to worry about the issue.

 

[Ingolf]

As well as me raising this issue (on at least 3 occasions I think), perhaps you had also missed this from the OP? If correct, it obviates the need to worry about the issue.

Yes, I saw the OP requirement but my response was to ravi 1986, in response to post number 20 "check Below the formula" ...

 

[Peter_SSs]

Yes, I saw the OP requirement but my response was to ravi 1986, in response to post number 20 "check Below the formula" ...

Fair enough, but your statement "And this formula result will be incorrect" is itself incorrect given the OPs statement of fact regarding duplicates, and that is all I was trying to point out - perhaps not directly enough.

Having said that, I think I would be implementing a solution that did allow for duplicates, just in case, hence my suggestions earlier in the thread.