lookup?

DieArd

Board Regular
Joined
Apr 21, 2007
Messages
157
HI Guys,
Sorry Im not very good at this one.

Please see the below link, pic on photobucket of my screen

http://i48.photobucket.com/albums/f206/dieard/top5.jpg

If you look at the first col, it is "month" I have this running upto june so far.

Basically this is a sheet showing how many sales each individual has made on the month.
I want to be able to put put on the right the top 5 people and their sales.

Would I use vlookup for this? again sorry i have never had to use this feature before.
Any suggestions would be great
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

DiscoPistol

Active Member
Joined
Jun 6, 2006
Messages
261
You can use these 3 functions

Code:
=MATCH(LARGE($D$4:$D$7,1),$D$4:$D$7,0)

in the next column

Code:
=INDEX($B$4:$D$7,G4,1)

and finally

Code:
=VLOOKUP(H4,$B$4:$D$7,3,0)

DP

Edit *I'm pretty sure there is a way you can combine those but I have a headache thinking about it....... :eek:
 

DieArd

Board Regular
Joined
Apr 21, 2007
Messages
157
thanks mate,
I have headache too..... "throws the pain killers over" take 2.
 

Expiry

Well-known Member
Joined
Jun 20, 2007
Messages
865
You could try using the =rank() formula. If their sales are in cells c1:c50, for example, insert a column to the left of your data (to enable the proceeding vlookup) and put =rank(c1,$c$1:$c$50), then drag down.

This will rank them from 1 to 50. Then, to the right, you can do a vlookup on rank 1, 2, 3 etc to display your top 5.
 

Stephan Hoenselaar

New Member
Joined
Jul 11, 2007
Messages
40
I think the easiest way is to use a Pivot table. You can use a pivot to rank performance and create a Top 5 by double clicking a Pivot Field selecting advanced... and creating a Top5. You can even select Month as a page field. This way you only need one Pivot to cover all of your desires...
 

Forum statistics

Threads
1,181,658
Messages
5,931,272
Members
436,786
Latest member
Deniel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top