Sort of minimum 5 from the undefined list which may can change every time along with its ties.

shekharverma

New Member
Joined
Jul 22, 2013
Messages
3
Dear ALL,

Please suggest:-

There are two Sheets Say "A" & "B" in one file.

There is a macros enabled in sheet A which reflect number of items per month from column E28:CF28(Total 80 items). If we want to calculate details of 70 item then we need to press 70 in one defined cell and then press start the list of 80 changed to 70 and last 10 columns get deleted.

Below E29 ie in E28 % is calculated of fixed 41 criteria listed in rows from D30 to D70.

According to macros if a want to calculate % of 70 item then last 10 item columns will get delete & Average percentage of each column comes in the E20 & for criteria (rows) average percentage comes in last of the row ance i fill Yes, No or NA. Row averge % calulation formulae get change automatically need not to put every time in a sheet.

Now i want to make graph of top 5 item & top 5 criteria. Since for top5 criteria rows are fixed for every month but for top 5 items number of items will vary every month. I want to put a formulae where i need not to change formule every month for top 5 items.

At present if i dont change formulae then error is reflecting and for top 5 list error is reflected.

I cannot delete macros from sheet A as the same is essential because every month no. of item changes.

Regards

Shekhar Verma
Mob:- 09717690615
shekharverma1@gmail.com
 

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