Sorting Cells Dynamically

[blaknite]

Hello,

I followed a tutorial from the extendoffice dot com website that demonstrates how to dynamically sort cells

It works but I was wondering 2 things:

1) I'm using this example for team standings in a league that I run, based on this example is it possible to make 1 list instead of 2 as this example demonstrates?

and

2) Using this example, Notebook has a value of 78, if I change Pen which has a value of 81 to 78, then what happens is the word Notebook gets changed to Pen? Why is this? how can I fix it? I implemented the code that it said to used for duplicate values but this seems to be a an unintended quirk.


Thanks

[Richard Buttrey]

Hi

Change A2 to

Please Login or Register  to view this content.

and copy down

Another option would be to use a Pivot Table on your data and set the PT to sort highest to lowest.
You'd need to refresh the PT after any change although you could have a sheet change macro do that automaticlly for you.

See attached.