+ Reply to Thread
Results 1 to 2 of 2

Ranking within a filtered list, in different column.

  1. #1
    Registered User
    Join Date
    06-01-2020
    Location
    Missouri, United States
    MS-Off Ver
    2016
    Posts
    1

    Post Ranking within a filtered list, in different column.

    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!
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,963

    Re: Ranking within a filtered list, in different column.

    Your formula OFFSET is working in Q column, try to replace with O column:
    Please Login or Register  to view this content.
    Copy to next green cells

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count Values in Filtered List / Return Final Row in a Filtered List
    By HarryGreenwood in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-22-2018, 06:52 AM
  2. [SOLVED] Add based on data of another column in filtered list
    By Margate in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-14-2018, 04:06 PM
  3. Data validation list, created from a filtered table range/column
    By Confuselocated in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2014, 11:28 AM
  4. [SOLVED] Excel VBA - Issue in Naming Filtered Range on a Filtered List.
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2014, 01:17 PM
  5. [SOLVED] Ranking up to 15 numbers in column D Ranking skips 7 with a tie at 6 and 2
    By Securitysports in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2013, 07:11 AM
  6. [SOLVED] Index and match based off of top 5 list for a specific field in a filtered column
    By ScottBeatty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-27-2013, 04:37 PM
  7. ranking formula for filtered data
    By ivansamsonov in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-27-2013, 11:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1