Question description:
This user has given permission to use the problem statement for this
blog.
I want to create Column C with a top three list. The data would be sorted by Column B and would also display the information from Column A i.e. if Column A2 is a name and B2 is a value, if it's the highest value of the column it would read A2 - B2 in Cell C2.
Solved by E. E. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
08/08/2018 - 08:30
Hi.. Welcome to Got It Pro
User
08/08/2018 - 08:30
Hello :)
Excelchat Expert
08/08/2018 - 08:30
How can I help you today?
User
08/08/2018 - 08:30
I need help with columns
User
08/08/2018 - 08:30
Can i edit the sheet here?
Excelchat Expert
08/08/2018 - 08:30
yes..
User
08/08/2018 - 08:31
Okay so
User
08/08/2018 - 08:31
I want create a top 3 list in D2
User
08/08/2018 - 08:31
for the data i've inputted
Excelchat Expert
08/08/2018 - 08:32
ok..
User
08/08/2018 - 08:32
in B2:B6 and C2:C6
User
08/08/2018 - 08:32
the top three would be based on the C column
User
08/08/2018 - 08:32
but also if possible display the names in the B column#
Excelchat Expert
08/08/2018 - 08:33
do you want to answers like this..??
User
08/08/2018 - 08:33
Yes :)
Excelchat Expert
08/08/2018 - 08:34
hold on..
Excelchat Expert
08/08/2018 - 08:34
let me work with the formula..
Excelchat Expert
08/08/2018 - 08:36
OK..
Excelchat Expert
08/08/2018 - 08:36
I made formula
Excelchat Expert
08/08/2018 - 08:36
on column D
User
08/08/2018 - 08:36
Oh thanks!
Excelchat Expert
08/08/2018 - 08:37
glad to help you out.
User
08/08/2018 - 08:37
So the $B$6 is just B6
Excelchat Expert
08/08/2018 - 08:37
$B$6
Excelchat Expert
08/08/2018 - 08:37
if you have larger range..
Excelchat Expert
08/08/2018 - 08:37
you need to change ranges in the formula also..
Excelchat Expert
08/08/2018 - 08:38
currently only cover from row 2 : 6..
User
08/08/2018 - 08:38
Right, i get you
User
08/08/2018 - 08:38
so instead of say b6, like b26 or something
Excelchat Expert
08/08/2018 - 08:38
yes..
Excelchat Expert
08/08/2018 - 08:38
with $..
User
08/08/2018 - 08:38
Alright thanks for your help buddy
Excelchat Expert
08/08/2018 - 08:39
no problem..
Excelchat Expert
08/08/2018 - 08:39
Is there anything else I can help you with this session?
User
08/08/2018 - 08:39
No thanks
Excelchat Expert
08/08/2018 - 08:40
Thank you for using the service.
Excelchat Expert
08/08/2018 - 08:40
If all is good now, please do end the session via the button on the upper right of your screen (sorry, can't do it from our end).
Excelchat Expert
08/08/2018 - 08:40
Don't forget to give additional feedback to help us improve this service!
Excelchat Expert
08/08/2018 - 08:40
♥¸.,·´`°³о♥ Have a nice day ♥¸.,·´` ..
User
08/08/2018 - 08:40
I'll leave it a little bit
User
08/08/2018 - 08:40
just copying some stuff
User
08/08/2018 - 08:40
over to my spreadsheet
Excelchat Expert
08/08/2018 - 08:40
no problem..
Excelchat Expert
08/08/2018 - 08:40
take your time..
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.