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
Sir pls give me answer
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
About this question
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
Please tell me your expected output
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
Please check out column D
Excelchat Expert
23/03/2018 - 02:02
Is that your desired output?
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.