Interactive sorting in Excel
Thread poster: Henrik Pipoyan

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


 

jaymin
Canada
Local time: 03:33
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






WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



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