Originally Posted by
Dave
Change "K" to either "A", "B" or "L".... any column which has data extending to the last row. I should have been more clear in my reply. Dave
So that worked, except now it pastes the values two rows lower than I want it to. So there are the headers, two blank rows, and then the values. I tried a few troubleshooting things, but nothing seemed to affect it much. As you can see its more than just an aesthetic issue. There are embedded formulas within the "Rank" Column which assigns a rank
=If(Cell to right <>"", Cell Above+1, "")
HAZNY - Ranking Page Doesn't Work.JPG
Reply With Quote
