Results 1 to 9 of 9

How do I rank cells from high to low?

Threaded View

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    Connecticut
    MS-Off Ver
    Excel 2010
    Posts
    32

    How do I rank cells from high to low?

    So I have a spreadsheet that has values in B15, E15, H15, K15, N15, Q15, T15 and W15. The headings of these values are in a merged cell of B5 & C5 via text. So B5&C5 say "Springfield" for example and the value in their B15 cell is $79,000. Each value cell has a text heading.

    How do I rank these cells from highest to lowest in a separate area of my spreadsheet that displays both the text and the value?

    Capture.PNG


    So it ranks and says on the side of the graph:

    1. Albany 107,900
    2. Glastonbury 94,975
    3. Middlebury 91,098
    4. Manchester 88,203
    5. Springfield 79,877
    6. Virginia Beach 64,418
    7. Southbury 60,108
    8. Brookfield 48,916

    Thank you in advance.
    Attached Images Attached Images
    Last edited by lanespoli; 07-18-2019 at 09:35 AM. Reason: Moderator making me

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Rank Teams in Performance Order - not as easy as just =Rank...
    By excelnat in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2015, 12:12 PM
  2. [SOLVED] Rank - Maintain Series if duplicate rank found
    By ascool_asice in forum Excel General
    Replies: 2
    Last Post: 10-11-2014, 12:35 PM
  3. Replies: 8
    Last Post: 02-20-2014, 07:03 PM
  4. Replies: 6
    Last Post: 11-30-2013, 09:14 AM
  5. Replies: 1
    Last Post: 11-30-2013, 06:48 AM
  6. Formula to Rank and populate values base don Rank
    By Excel Dumbo in forum Excel General
    Replies: 3
    Last Post: 10-09-2012, 02:02 AM
  7. Replies: 1
    Last Post: 08-15-2005, 05:05 PM

Tags for this Thread

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