Hi,

If I have a list of text and data is it possible for excel to sort by
decreasing automatically without the user having to do it each time? Example

from this to
Bill 1 Jane 5
Fred 2 Ted 3
Jane 5 Fred 2
Ted 3 Bill 1
Gem 1 Gem 1

Hence if i then change Jane to 0 excel will automatically put her in last
place. I want to use the second chart to plot a graph which will also update
automatically with the new order.

Anyone know?

Thanks