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

[shekharverma]

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