**Question description:**

*This user has given permission to use the problem statement for this blog.*

If I wanted to rank a set of values in different cells, all in the same column or all in the row from lowest to highest, without sorting, how would I do that? . e.g. Cell A2=14.3, A3=5.6, A4=8.9, A5=11.3, and A6=2.4 How could I put a ranking in column B to show that Cell A6 ranked 1st, A3 2nd, etc...?

Solved by E. S. in 13 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
15/05/2018 - 08:32

Hi

Excelchat Expert
15/05/2018 - 08:32

Welcome to Got it Pro

Excelchat Expert
15/05/2018 - 08:32

Can you share your data and explain more on the requirements

User
15/05/2018 - 08:33

I can type values in this sheet, but I can't share the actual data.

Excelchat Expert
15/05/2018 - 08:33

ok

User
15/05/2018 - 08:34

Can a formula rank these values from one to five in row 4?

Excelchat Expert
15/05/2018 - 08:34

ok

Excelchat Expert
15/05/2018 - 08:34

Let me put the formula

Excelchat Expert
15/05/2018 - 08:36

Ranked in ascending order

User
15/05/2018 - 08:36

Is there a limit to the number of variables that may be ranked?

Excelchat Expert
15/05/2018 - 08:37

Limit the variables mean?

User
15/05/2018 - 08:37

Say my data went out to Column Z, Could it rank all of those columns?

Excelchat Expert
15/05/2018 - 08:38

Yes

Excelchat Expert
15/05/2018 - 08:38

It will rank as many columns as you want

User
15/05/2018 - 08:38

In the formula the last entry, 0 or 1 is that what determines if it ranks lowest to highest and visa versa?

Excelchat Expert
15/05/2018 - 08:38

Yes exactly

Excelchat Expert
15/05/2018 - 08:39

That is why i showed you both the formula

User
15/05/2018 - 08:39

And in cell b4, that formula (B3, is that designating the first cell to start the ranking?

Excelchat Expert
15/05/2018 - 08:40

=RANK(B3,$B$3:$F$3,1)

Excelchat Expert
15/05/2018 - 08:40

This finds the rank of B3, from range B3 to F3 in ascending order

User
15/05/2018 - 08:40

What if the value in two or more of the cells is the same, what results do you get?

Excelchat Expert
15/05/2018 - 08:41

you can make the result same and then see

Excelchat Expert
15/05/2018 - 08:41

They will get same rank

User
15/05/2018 - 08:42

Ok, and it skips the ranking number, in this case #3 is not showing as there are two #2 rankings. That's perfect.

Excelchat Expert
15/05/2018 - 08:42

Yes exactly

Excelchat Expert
15/05/2018 - 08:43

Hope this session has helped you

User
15/05/2018 - 08:43

If the data was in columns the calc is the same i imagine?

Excelchat Expert
15/05/2018 - 08:43

yes

User
15/05/2018 - 08:43

Great! you have been a great help today.

Excelchat Expert
15/05/2018 - 08:43

It will work exactly the same

Excelchat Expert
15/05/2018 - 08:43

Thanks

Excelchat Expert
15/05/2018 - 08:43

Please do give good rating and reviews

Excelchat Expert
15/05/2018 - 08:44

It really helps a lot

User
15/05/2018 - 08:44

In the future is the charge $10 per session?

Excelchat Expert
15/05/2018 - 08:44

I have no idea, you will needto ask support team for that

User
15/05/2018 - 08:44

Ok, need to run, Thanks again. I'll provide an excellent review.

Excelchat Expert
15/05/2018 - 08:45

Thanks

Excelchat Expert
15/05/2018 - 08:45

Have a great day

Excelchat Expert
15/05/2018 - 08:45

Take Care

User
15/05/2018 - 08:45

Bye.:)

Excelchat Expert
15/05/2018 - 08:45

You can provide your rating once you end the session

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*