Excel - IF Function Problem - Expert Solution

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.

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.