Excel: Help for formula to find Top 3 value in excel


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
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
If group number is 2 in sheet1 then top 3 value will be like this- Group2
Name Value
Rubel 172569
Hasin 152304
Monem 104463
If group number is 3 in sheet1 then top 3 value will be like this-
Name Value
Romel 168251
Nasim 136357
Hasan 120410
Please help me if anyone know the formula. Thank you in advance for your help. Best Regards Emran


This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of April 20, 2014.


For more resources for Microsoft Excel