**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.*