# Dynamically Rank Rows

• ### 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

• Perhaps

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

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

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

### All replies

• Perhaps

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

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

• Marked as answer by Thursday, July 12, 2018 7:27 PM
Thursday, July 12, 2018 7:19 PM
• Thanks, that worked
Thursday, July 12, 2018 7:27 PM