D Dennis Noble Jun 13, 2009 #1 Formula Rank=(A1:A9,A$1:A$9,1) this is working well but! I need to reverse the order to high # equal 1st not last
Formula Rank=(A1:A9,A$1:A$9,1) this is working well but! I need to reverse the order to high # equal 1st not last
S Shane Devenshire Jun 13, 2009 #3 Hi, You should simplify the formula to read: =RANK(A1,A$1:A$9) for descending =RANK(A1,A$1:A$9,1) for ascending using A1:A9 for the first argument instead of A1 gains nothing and is overkill.
Hi, You should simplify the formula to read: =RANK(A1,A$1:A$9) for descending =RANK(A1,A$1:A$9,1) for ascending using A1:A9 for the first argument instead of A1 gains nothing and is overkill.
