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.
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.