Interactive sorting in Excel
Thread poster: Henrik Pipoyan

Henrik Pipoyan  Identity Verified
Local time: 12:39
Member (2004)
English to Armenian
Feb 5, 2010

Does anyone know a way to sort a list in Excel so that it changes automatically when values change? I have my clients' list and the number of projects for each client. It's sorted in alphabetical order. I am trying to make a new list on another sheet, linked to the original list, and sort it by the number of projects, so that when the numbers change on the original list, the order of the second list changes automatically. I have tried the "rank" function and it works as long as there are no repeated numbers. But as soon as two clients have the same number of projects, it gives an error. Any ideas how this can be done?

Thank you for your help.


Local time: 03:39
Member (2009)
German to Korean
+ ...
macro will do it Feb 5, 2010

you may want to create a simple macro in excel.

hope it helps.

[Edited at 2010-02-05 21:20 GMT]


To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Interactive sorting in Excel

Advanced search

Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for users! Save over 13% when purchasing Wordfast Pro through Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search