how do i automatically sort a list

  • Thread starter Defoes Right Boot
  • Start date
D

Defoes Right Boot

I have a range of indeterminate length consisting of 3 columns (name, team,
goals - it's a top-scorer list.)

What I want to do is have Excel automatically sort the full range based on
the Goals column whenever data is added to the list (ie new scorer entered)
or edited (ie existing scorer gets another goal.) to keep the list always in
order of most goals scored.

Anyone got any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sort a list automatically? 1
What formula do I use for copying cell information between workboo 2
How do I count occurances of a specific character in a range? 1
Automatic sort macro 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
How can I sort a group of numbers automatically as data is entere 4
Automatically sort alphabetically ignoring header 2
List sorting and macros 3

Top