High light range number

avisoft20

Board Regular
Joined
Sep 10, 2016
Messages
64
Dear Expert,
I have a database given below i want to calculate top 5

first top 5 multiply by 10 in next column i.e PERCENT column.
first top 5 multiply by 7.5 in next column i.e PERCENT column.
first top 5 multiply by 5 in next column i.e PERCENT column.

Calculation range changed when party name chaned

for example i have also attached jpeg for best understand my query.


[TABLE="width: 690"]
<tbody>[TR]
[TD]Party Name[/TD]
[TD]Brand (GRP-1)[/TD]
[TD]Prod.hier.Details[/TD]
[TD]TOTAL[/TD]
[TD]Percent[/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]AARTI[/TD]
[TD]Steam Premium[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Long Grain[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Tibar[/TD]
[TD]42[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Super[/TD]
[TD]950[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Tibar[/TD]
[TD]650[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Brown Wand[/TD]
[TD]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Classic[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Kinki[/TD]
[TD]125[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mini Mogra[/TD]
[TD]70[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mogra[/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Steam Wand[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Tibar[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Mini Dubar[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Super Tibar[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Feast Rozzana[/TD]
[TD]96[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Supreme[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Dubar[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES-TOTAL
[/TD]
[TD][/TD]
[TD][/TD]
[TD]2258[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]AARTI[/TD]
[TD]Steam Premium[/TD]
[TD]125[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Long Grain[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Tibar[/TD]
[TD]96[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Super[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Brown Wand[/TD]
[TD]75[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Classic[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Tibar[/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Kinki[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mini Mogra[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mogra[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Feast Rozzana[/TD]
[TD]42[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Steam Wand[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Super Tibar[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Supreme[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Tibar[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Mini Dubar[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Dubar[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES-TOTAL[/TD]
[TD][/TD]
[TD][/TD]
[TD]660[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

LINK : https://drive.google.com/open?id=1LjatuP7SWQxpxKDV4Yobek3vQH8Ews6B
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
what do you mean by first top 5 ?

for AASHIRWAD AGENCIES you have 17 totals

the percent column is blank - will that be % of 2258 ?
 
Upvote 0

Forum statistics

Threads
1,223,900
Messages
6,175,276
Members
452,629
Latest member
SahilPolekar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top