# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Sir I have 2 column A bank name B Revenue I want to get who bank name revenue in top and who in second
Solved by G. Y. in 25 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/03/2018 - 01:41
Hi buddy
Excelchat Expert 23/03/2018 - 01:41
Welcome to got it pro
User 23/03/2018 - 01:42
Hi
User 23/03/2018 - 01:42
Sir
Excelchat Expert 23/03/2018 - 01:43
Hi buddy
User 23/03/2018 - 01:43
Sir this is my question
User 23/03/2018 - 01:43
I have no file for attach
User 23/03/2018 - 01:44
User 23/03/2018 - 01:45
I have 2 column A bank name and B Revenue I want to know that who bank in top in revenue
Excelchat Expert 23/03/2018 - 01:46
Ok, is my example alright?
User 23/03/2018 - 01:46
And who in 2nd who in 3rd I have 20 bank so I want to rank all bank
Excelchat Expert 23/03/2018 - 01:47
alright..
Excelchat Expert 23/03/2018 - 01:48
The easiest way is to use the SORT button
Excelchat Expert 23/03/2018 - 01:48
but if this is not ok, you can also use conditional formatting for visual reference
Excelchat Expert 23/03/2018 - 01:49
But, if those two wont do, then, do you prefer a third column where you can have the ranking of each bank?
User 23/03/2018 - 01:50
Sir pls send me file
User 23/03/2018 - 01:51
Excelchat Expert 23/03/2018 - 01:51
Can you see my example on the right side?
Excelchat Expert 23/03/2018 - 01:51
Using the rank function is very easy
Excelchat Expert 23/03/2018 - 01:52
I'll put the formula on column C
Excelchat Expert 23/03/2018 - 01:53
Did you see it?
User 23/03/2018 - 01:53
No sir
User 23/03/2018 - 01:53
This is not right
Excelchat Expert 23/03/2018 - 01:53
Huh?
Excelchat Expert 23/03/2018 - 01:53
What do you mean "no"?
Excelchat Expert 23/03/2018 - 01:53
can you elaborate?
Excelchat Expert 23/03/2018 - 01:54
User 23/03/2018 - 01:54
I want to show revenue in C column
User 23/03/2018 - 01:54
Not rank
User 23/03/2018 - 01:56
But top to bottom
User 23/03/2018 - 01:56
And there are show bank name
Excelchat Expert 23/03/2018 - 01:56
Can you please give some examples?
User 23/03/2018 - 01:57
Bank name
Excelchat Expert 23/03/2018 - 01:58
alright, im trying to check it again
Excelchat Expert 23/03/2018 - 01:58
hang on for aa while
Excelchat Expert 23/03/2018 - 02:00
alright, try this
Excelchat Expert 23/03/2018 - 02:00
please extend the session a little bit
Excelchat Expert 23/03/2018 - 02:02
Excelchat Expert 23/03/2018 - 02:02
Excelchat Expert 23/03/2018 - 02:03
each bank has been arrange according to its revenue
Excelchat Expert 23/03/2018 - 02:03
Top most is the one with the highest revenue
Excelchat Expert 23/03/2018 - 02:03
If that is ok, I'll be glad to explain the formula to you

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.