+ Reply to Thread
Results 1 to 4 of 4

Rank countif with index match is not giving top results

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    O365
    Posts
    311

    Rank countif with index match is not giving top results

    Hello,

    I have the attached file. On the entire report tab in column k AU I have a rank formula that assigns the data a rank from lowest to highest based on one of the other columns. On the summary tab I have an index match formula that is supposed to go to the entire report tab and pull the top largest and another section that pulls the top lowest based on the rank. The formula on the summary tab is pulling a result but it isn't starting with the largest number. I cannot figure out what is wrong. Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Rank countif with index match is not giving top results

    Maybe in part ROW() add up with this ROW(A1)

  3. #3
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    O365
    Posts
    311

    Re: Rank countif with index match is not giving top results

    I believe that fixed it. Thanks!

  4. #4
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Rank countif with index match is not giving top results

    You're welcome

+ 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] Index, Match and Indirect giving REF error
    By stanleds in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2013, 06:08 AM
  2. COUNTIF giving wrong results
    By Excel_vba in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-29-2013, 04:17 PM
  3. Lookup or match function with multiple criteria giving different results
    By Mian USman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-24-2013, 09:15 AM
  4. [SOLVED] pull next Rank on an Index/Match w/Max that uses (Countif) when IF
    By Dj Duck in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-11-2013, 12:31 PM
  5. [SOLVED] Using Index Match or Vlookup giving unexpected results on imported data
    By jacob@thepenpoint in forum Excel General
    Replies: 2
    Last Post: 07-03-2012, 05:49 PM

Tags for this Thread

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