+ Reply to Thread
Results 1 to 19 of 19

Need a formula to rank data within a column

  1. 02-22-2020, 05:55 AM #1
    khanaran
    khanaran is offline
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Need a formula to rank data within a column

    Greetings

    I need some help with a formula that will be able to automate the ranking of my data in Col O and Colum

    The length of the columns are not constant the length changes


    Thank you in advance for all the help

    Regards

    raj


    I am currently doing it manually by changing the cells
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-22-2020, 05:59 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,444

    Re: Need a formula to rank data within a column

    Which version of Excel are you using? You may need to update your forum profile.

    Where have you mocked up what you want to see? I cannot see anywhere where column lengths vary ...
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 02-22-2020, 06:11 AM #3
    khanaran
    khanaran is offline
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Need a formula to rank data within a column

    Hi

    Hi

    Many thanx for the reply

    My apology attached wrong file now corrected

    am using excel version 2019
    regards

    Raj
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 02-22-2020, 06:11 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,444

    Re: Need a formula to rank data within a column

    Thanks. Please update your forum profile whilst I have a look at your workbook.
    Reply With QuoteRegister To Reply
  5. 02-22-2020, 06:13 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,444

    Re: Need a formula to rank data within a column

    OK - I am really sorry, but I am not really clear on the problem. Your ranking formulae seem fine - what am I missing? What is it about column lengths that concerns you? Why not just convert the ranges to dynamic tables?
    Attached Files Attached Files
    Last edited by AliGW; 02-22-2020 at 06:16 AM.
    Reply With QuoteRegister To Reply
  6. 02-22-2020, 06:16 AM #6
    BMV
    BMV is offline
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Need a formula to rank data within a column

    Try 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 02-22-2020, 06:18 AM #7
    khanaran
    khanaran is offline
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Need a formula to rank data within a column

    Hi

    the formula are fine

    when I update my data file, the length of each race differs so have to changes all the references

    I wanted to know if a formula can be used so that it changes the references for the cells based on the number of rows and between two separate sets of data

    Some races have 8 entries some eleven and some upto fourteen

    regards

    Raj
    Reply With QuoteRegister To Reply
  8. 02-22-2020, 06:20 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,444

    Re: Need a formula to rank data within a column

    Did you not see my suggestion and attachment?
    Reply With QuoteRegister To Reply
  9. 02-22-2020, 06:31 AM #9
    khanaran
    khanaran is offline
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Need a formula to rank data within a column

    Hi

    my apologies

    missed read the message

    thanx for the advice

    Regards

    raj
    Reply With QuoteRegister To Reply
  10. 02-22-2020, 06:32 AM #10
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,444

    Re: Need a formula to rank data within a column

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  11. 02-22-2020, 06:32 AM #11
    khanaran
    khanaran is offline
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Need a formula to rank data within a column

    Hi

    tried

    copied and posted

    somehow must be doing something wrong

    not getting it to read the formula

    raj
    Reply With QuoteRegister To Reply
  12. 02-22-2020, 06:35 AM #12
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,444

    Re: Need a formula to rank data within a column

    What do you mean? You don't copy and paste. Just select the original table in its entirety, including your additional columns (do each table in turn) and go Insert > Table. That's it - then the formulae will grow as you add rows.
    Reply With QuoteRegister To Reply
  13. 02-22-2020, 06:39 AM #13
    khanaran
    khanaran is offline
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Need a formula to rank data within a column

    hi

    Many thanks for the correction

    I was actually responding to the message received from @BMV

    regards
    Reply With QuoteRegister To Reply
  14. 02-22-2020, 06:48 AM #14
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,444

    Re: Need a formula to rank data within a column

    Then you should have made that clear. Start your posts with @BMV, or similar, please.
    Reply With QuoteRegister To Reply
  15. 02-22-2020, 06:57 AM #15
    BMV
    BMV is offline
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Need a formula to rank data within a column

    khanaran, replace separator from ; то , and i am not sure i used correct file. If you need universal formula i ill be back in 4h.
    Last edited by BMV; 02-22-2020 at 07:02 AM.
    Reply With QuoteRegister To Reply
  16. 02-22-2020, 07:58 AM #16
    khanaran
    khanaran is offline
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Need a formula to rank data within a column

    Hi
    Thank You

    working
    Raj


    just a further question can this formula be written into my script

    Raj
    Last edited by khanaran; 02-22-2020 at 08:00 AM.
    Reply With QuoteRegister To Reply
  17. 02-22-2020, 10:10 AM #17
    BMV
    BMV is offline
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Need a formula to rank data within a column

    One for all 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  18. 02-22-2020, 12:33 PM #18
    khanaran
    khanaran is offline
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Need a formula to rank data within a column

    Hi

    Thank you so much

    Regards

    Raj
    Reply With QuoteRegister To Reply
  19. 02-22-2020, 12:39 PM #19
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,444

    Re: Need a formula to rank data within a column

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sorting a column based on data in another column? (RANK?)
    By Mr Frost in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-04-2016, 04:49 AM
  2. [SOLVED] Ranking Help - Rank formula to exclude data from ranking (like a rank if kind of function)
    By harp1983 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2016, 06:55 PM
  3. [SOLVED] forcing a rank on 1 through 5 (no dups) using the rank formula in Excel
    By denver1717 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-22-2015, 08:28 AM
  4. [SOLVED] Formula to Rank the number of times a word appears in a column dynamic with Sorting
    By caliskier in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-02-2014, 04:26 PM
  5. [SOLVED] Having an issue with a formula used to rank column numbers earlier but now is failing .
    By Securitysports in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-02-2013, 06:04 PM
  6. Excel 2007 : Resolving ties in rank formula (tie in original column + tie in 2nd column)
    By CRIMEDOG in forum Excel General
    Replies: 3
    Last Post: 08-02-2013, 02:16 PM
  7. 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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1