View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
kyle obryan kyle obryan is offline
external usenet poster
 
Posts: 1
Default Wont work..

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