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
<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
<tbody>
</tbody>
If group number is 2 in sheet1 then top 3 value will be like this-
Group2
<tbody>
</tbody>
If group number is 3 in sheet1 then top 3 value will be like this-
<tbody>
</tbody>
Please help me if anyone know the formula. Thank you in advance for your help.
Best Regards
Emran
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