Forum Discussion
listing items in ranked order
willowbe Must admit that not reading a question properly can create problems. I've now created a work-around by introducing a helper column. In this column a unique ranking number, a fraction lower than the real one, is calculated. This will make my original formula work as it was planned to. Have a look at the attached workbook.
willowbe could you use the sort function on the data set? Where it could look like:
=SORTBY(A2:B11, B2:B11, -1)
Where your data is in columns A and B. You want to sort by the values in column B. Putting a -1 at the end sorts them highest to lowest.
cdolan27 I love the simplicity of this suggestion but "SORTBY" does not appear to be a working function in my version of Excel! I'm using Excel as part of Office 365, which I thought meant I would get all the newest bells and whistles, but a quick Googling tells me that SORTBY is in beta, and has only been rolled out to a "select number of office insiders." nikita how do I become one of these insiders???
Thanks Patrick2788 but unfortunately I'm using Office through my job so I have to wait for the IT department to respond to my request to be added to the Insider list. 😕
