# Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.