3 Replies Latest reply on Jul 29, 2016 10:52 AM by Brian Enderson

    Index() Rank with Conditions

    Brian Enderson

      In the attached workbook, I'm trying to use an Index() to rank Names based upon their Score, but also based upon the condition that their Count is above the median. I'm using Sum(Count) > Window_Median(Sum(Count)) statement to show how I want to rank the Names, but when I remove the "False" rows the Index() still includes them in the rank. Ideally I'd like the Index() to count 1-2-3 etc for the True row and 1-2-3 etc for the False rows. Any ideas on how I can achieve this?