I have figured out how to rank a given cell within the numbers in the column below. See attached example: A4 is ranked 40 out of 76 results. If I filter the column to show only cities under 30,000, then it is now ranked 11 out of 47. (it doesn't count cells that are hidden due to filtering)
Where I run into an issue is when I need to rank a number within a different column. I have highlighted the cells I am referring to. I need to rank the three BLUE cells (Q4, S4, and U4) all within the BLUE column results in O. I tried using the same formula that is in cell O5, and editing the column, but something is throwing it off. It keeps showing the rank as "1", no matter what I type in cell Q4.
Any suggestions would be appreciated!
Bookmarks