I have an attendance sheet with several columns(one for vacation taken, sick
days taken,personal days taken) is based on a rolling year. I have a
formula and that works fine, BUT Here comes the issue. Days taken have to
be shown in decending order. I tried adding rows and shifting rows down
but for abvious reasons that does not work.

IF I add the information at the bottom of the coulmn, sort it again in
descending order and recalculate the totals it works but that is very
manual and time consuming ( the attendance sheet has over 100 names)
Is there an easier way? pleeease