Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort horizontally?
Hello,
I'm wondering if there's a way to arrange numbers from the largest to the smallest when those numbers are in a row. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort horizontally?
There is:-
Select your row then:- data|Sort|Options|Left to right Select ascending or descending Click OK Mike "Niniel" wrote: Hello, I'm wondering if there's a way to arrange numbers from the largest to the smallest when those numbers are in a row. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort horizontally?
Cool, that wasn't all that difficult.
Just out of curisosity - can this be programmed as well? So that when my input cells get populated, I can pick up the re-arranged numbers in another row without having to do anything else? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort horizontally?
I suspect you would have to resort to VBA for that utilising something like
the worksheet_change event. Mike "Niniel" wrote: Cool, that wasn't all that difficult. Just out of curisosity - can this be programmed as well? So that when my input cells get populated, I can pick up the re-arranged numbers in another row without having to do anything else? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort horizontally?
Say that your original numbers are in Row 1.
Enter this formula *anywhere* (except Row 1), and drag across to copy as needed: =LARGE(1:1,COLUMNS($A$1:A1)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Niniel" wrote in message ... Cool, that wasn't all that difficult. Just out of curisosity - can this be programmed as well? So that when my input cells get populated, I can pick up the re-arranged numbers in another row without having to do anything else? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort horizontally?
Very cool!
I had to tinker with it a bit since I had other date in the same row that I didn't want sorted, but I just moved my target data to an otherwise empty row, so now it's working like a charm. Thanks a lot! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort horizontally?
You can configure the formula to reference a pre-determined range, so that
you could use the rest of the row for your other data. For example, say your original numbers were only occupying, say 15 columns, from V9 to AJ9. You could then enter this formula *anywhere*: =LARGE($V$9:$AJ$9,COLUMNS($A$1:A1)) Even in say B9, and copy it across to P9. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Niniel" wrote in message ... Very cool! I had to tinker with it a bit since I had other date in the same row that I didn't want sorted, but I just moved my target data to an otherwise empty row, so now it's working like a charm. Thanks a lot! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort horizontally?
Thank you. Now my little calculator sheet looks even nicer. :)
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort horizontally?
You're welcome, and thanks for the feed-back.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Niniel" wrote in message ... Thank you. Now my little calculator sheet looks even nicer. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different columns according to value horizontally | Excel Discussion (Misc queries) | |||
Cumulative sum on Condition (Horizontally) | Excel Worksheet Functions | |||
Filter horizontally? | Excel Worksheet Functions | |||
Autofilter horizontally? | Excel Discussion (Misc queries) | |||
copying data horizontally | Excel Worksheet Functions |