Interactive sorting in Excel
Thread poster: Henrik Pipoyan

Henrik Pipoyan  Identity Verified
Local time: 07:54
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
 

jaymin
Canada
Local time: 22:54
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 ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »
LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search