question on sorting

N

namsilat

Imagine I have 5 columns of numbers (say A to E), and I am trying to
create a master list elsewhere (say column G) on the same spreadsheet
that sorts all five columns of numbers into either ascending or
desending order. To make matters worse, numbers in column A to E are
not just raw numeric value; they are calculated from other forumula or
functions.

I thought about several methods making use of copy or sort, but I
can't think of a way to just sort the numbers in column A to E
automatically as the numbers change on the flight. Any idea would be
greatly appreciated.
 

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

Top