Trying to auto sort every time table is updated and calculate percentage

**m1cks** · 07-14-2019, 12:52 PM

Hi all. Really impressed with the help I got on my last thread so hoping you can help again.

I have a table of 12 rows that gets its figures from three other tables. I'd like for the data to autosort to keep the highest figure at the top (obviously the row with the highest figure may change when the other 3 tables update) I'd also like it to work out the percentage of the total each row accounts for.

I have attached a dummy copy as previously requested so you can see whats required. The table is highlighted in yellow.

**Bo_Ry** · 07-14-2019, 01:37 PM

Please try at
B32
=INDEX(H:H,MOD(LARGE(INDEX(SUMIFS($I$32:$U$43,$H$32:$T$43,$H$32:$H$43)*10^6+ROW($H$32:$H$43),),ROWS(B$32:B32)),10^3))

C32
=LARGE(INDEX(SUMIFS($I$32:$U$43,$H$32:$T$43,$H$32:$H$43),),ROWS(C$32:C32))

D32 use average
=IFERROR(SUMIFS($K$32:$W$43,$H$32:$T$43,B32)/3,)

**m1cks** · 07-14-2019, 02:00 PM

Thank you.
With the average, what I was after was for the whole of column C to be added together (1056) and then divided into a percentage and then each row to display its representative percentage on each row

E.G.
row 32 = 441 of 1056 = 41.86%
row 33 = 216 of 1056 = 20.45% as so on....

**Bo_Ry** · 07-14-2019, 02:36 PM

Then E32
=C32/SUM($C$32:$D$43)

**m1cks** · 07-14-2019, 03:51 PM

Thank you Bo_Ry

Trying to auto sort every time table is updated and calculate percentage

LinkBack

Thread Tools

Rate This Thread

Display

Trying to auto sort every time table is updated and calculate percentage

Re: Trying to auto sort every time table is updated and calculate percentage

Re: Trying to auto sort every time table is updated and calculate percentage

Re: Trying to auto sort every time table is updated and calculate percentage

Re: Trying to auto sort every time table is updated and calculate percentage

Thread Information

Users Browsing this Thread

Similar Threads

VBA code to uncheck "Sort automatically every time the report is updated" of Pivot table?

Auto Calculate Macros when worksheet data updated or changes in multiple cells

Auto sort when updated

Auto Sort, Auto Lock, Auto Date & Time Stamp

[UPDATED] excel 2007 worksheet to HTML website. auto refresh/calculate?

auto-calculate percentage formula

Bookmarks

Bookmarks

Posting Permissions