ExcelBanter - Numerating Cells.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Numerating Cells. (https://www.excelbanter.com/excel-discussion-misc-queries/238869-numerating-cells.html)

GEM

Numerating Cells.

Is there a way to numerate cells. For example.

A1=20
A2=22
A3=5
A4=12

The results I want in column B are the following
B1=2
B2=1
B3=4
B4=3

Because, A2 is the highest number, A1 is the second highest, A4 is the 3rd
highest and finally A3 is the fourth highest.

Luke M

Numerating Cells.

In B1:
=RANK(A1,$A$1:$A$4)

Copy down as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"GEM" wrote:

Is there a way to numerate cells. For example.

A1=20
A2=22
A3=5
A4=12

The results I want in column B are the following
B1=2
B2=1
B3=4
B4=3

Because, A2 is the highest number, A1 is the second highest, A4 is the 3rd
highest and finally A3 is the fourth highest.

Per Jessen[_2_]

Numerating Cells.

Hi

Look at the Rank() function, insert the formula below in B1 and copy
it down.

=RANK(A1;$A$1:$A$4)

Regards,
Per

On 4 Aug., 20:46, GEM wrote:
Is there a way to numerate cells. For example.

A1=20
A2=22
A3=5
A4=12

The results I want in column B are the following
B1=2
B2=1
B3=4
B4=3

Because, A2 is the highest number, A1 is the second highest, A4 is the 3rd
highest and finally A3 is the fourth highest.

All times are GMT +1. The time now is 10:08 PM.