I Need Help

Mch · Aug 22, 2004

When using rank it assigns duplicates the next higher number in rank.Ho
do you avoid thi

Frank Kabel · Aug 22, 2004

Hi
see your other post

Fable · Aug 23, 2004

Here's a possible solution:

=RANK(C7,C$7:C$16)+COUNTIF(C$7:C7,C7)-1

Fabl

USB Com ports	6	Jun 6, 2020
RANK Function	3	Mar 5, 2007
Problems Rank Ordering	4	Jul 9, 2007
RANK not resulting as hoped	8	Apr 24, 2008
Rank Function - Ranking Array Size Limit	1	Dec 19, 2008
Ranking query	2	Apr 1, 2008
RANK - dont include zeros	5	Apr 28, 2009
RANK and CORRELATION	7	Nov 25, 2005

Ask a Question