Am I just not putting the information in correctly for this?
=MODE(IF(COUNTIF(L$8:L8,C$1:C$1577)=0,C$1:C$1577+{ 0,0}))
I have the mode in cell L8 and my data im trying to get the 2nd, 3rd, and 4th instead of just mode is in cells c1:c1577
Thanks in advance
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng