Interactive sorting in Excel
Thread poster: Henrik Pipoyan

Henrik Pipoyan  Identity Verified
Local time: 12:24
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.

Direct link Reply with quote

Local time: 04:24
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]

Direct link Reply with quote

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

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 »
SDL Trados Studio 2017 only €415 / $495
Get the cheapest prices for SDL Trados Studio 2017 on

Join this translator’s group buy brought to you by and buy SDL Trados Studio 2017 Freelance for only €415 / $495 / £325 / ¥60,000 You will also receive FREE access to our getting started eLearning program!

More info »

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