none
Dynamically Rank Rows RRS feed

  • Question

  • I have a spreadsheet that gets a feed from a website, so the amount of rows will always differ. I want to be able to rank the rows based on data in column E, but I'd like to only get the number of rows that have data in column A

    I have this formula that dynamically sets the rank range, but how do I make the lower bound of the range a cell range that the formula will reference instead of a string? Will INDIRECT work?

    =Rank(E3, $E$2:$E$ & CountA(A:A))

    Thursday, July 12, 2018 7:05 PM

Answers

  • Perhaps

    =RANK(E3,OFFSET($E$2,0,0,COUNT($A:$A),1))


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by JHarding08 Thursday, July 12, 2018 7:27 PM
    Thursday, July 12, 2018 7:19 PM

All replies