Thread: Rank Tie
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default Rank Tie

Maybe...

=IF(B69="","",SUMPRODUCT(--(B69<B$69:B$77),1/COUNTIF(B$69:B$77,B$69:B
$77&""))+1)

Biff's response to what I think could be the same type of ranking
request.

Ken Johnson

Reply With QuoteReply With Quote