+ Reply to Thread
Results 1 to 2 of 2

Automatic sorting of values

  1. #1
    Registered User
    Join Date
    04-02-2015
    Location
    florida, usa
    MS-Off Ver
    360
    Posts
    34

    Automatic sorting of values

    Please see attached excel sheets....

    "c|dev 1" has a combination of data from a variety of sources through the workbook
    "c| dev 2" has the calculations I am working on


    Another user of this forum helped me with these formulas... so I am not an expert.

    In sheet "c| dev 2" columns b&c have related data (and d&e, f&g)

    Is there a way to have this show up from highest value in the second column (e,f,g) to least value?

    -Automatically, that is....

    property use 2.0-1.xlsx

  2. #2
    Registered User
    Join Date
    04-02-2015
    Location
    florida, usa
    MS-Off Ver
    360
    Posts
    34

    Re: Automatic sorting of values

    sheet new.PNGproperty use 4-2-15.xlsxOkay I am adding additional information...

    The image shows the table I have worked on. The one on the right is what I would like formulas to do. It would look at the upper left section and sort by value and put those in the right table. It would then move to the middle left section and finally the bottom left section.

    Similarly, it would do the same for the "developer" and municipal columns.

    Does anyone know how to sort it like this without cells extra cells between the items? Sometimes, the numbers may be equal to each other it just would need to list both.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatic Sorting
    By hockey99 in forum Excel General
    Replies: 8
    Last Post: 03-09-2012, 05:03 PM
  2. Replies: 2
    Last Post: 06-17-2011, 03:00 PM
  3. Max & Min Automatic Sorting
    By rickyilas in forum Excel General
    Replies: 3
    Last Post: 06-21-2010, 05:42 AM
  4. Automatic sorting?
    By controlfreak in forum Excel General
    Replies: 2
    Last Post: 06-04-2009, 07:28 AM
  5. Automatic Sorting
    By paulwelburn in forum Excel General
    Replies: 9
    Last Post: 05-18-2007, 12:56 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1