Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting left to right in Excel (Excel 2000)

    My question is: (Attached Excel File)
    I have percent totals on this sheet in cells B10:H10. I have the same cells pasted as a link on Sheet 2! Cells B10:H10, with conditional formatting placed on those cells to color code them depending on their value.
    I need a way to sort from left to right (which I can do) the cells on Sheet 2! in Ascending order. But when the data changes on Sheet 1! , I want the cells to continue their Ascending sort from left to right on Sheet 2!, without having to resort them. Is there a way to accomplish this task? Thanks for all who would look at the attached file (Sheet 1 and 2) and tell me what they think.
    Nannette
    Attached Files Attached Files
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Sorting left to right in Excel (Excel 2000)

    Attached using array formulae seems to work.
    Attached Files Attached Files
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting left to right in Excel (Excel 2000)

    John,
    I am always amazed at the knowledge here. You are absolutely fabulous. Thank you, so very much for your time, and your expertise...the formulae is exactly what I needed. I appreciate you taking the time to look at this worksheet and come up with this array formulae for me. Your a genius!!!
    Indebted...
    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •