i am a teenage boy and new to this kind of works, so sorry if i am asking a
fulish thing, but i need an answer.
i need to know how i can sort out some datas that are in an excel sheet
AUTOMATICALY
and if it is not possible i need to know how i can do the following one. it
is a football table and i need to know the top scorrers. i have used " rank
for goal and vlookup for players and country" . plaese help me to do this?

All Players Top 05
Goals Player Country S. No Player Country Goals
3 Ashfaq Maldives 1 Sofwan Maldives 6
4 Ali Umer Pakistan 2 Sofwan Maldives 6
5 Thorig India 3 Thorig India 5
6 Sofwan Maldives 4 Thorig India 5
2 Mohamed Pakistan 5 Ali Umer Pakistan 4
6 Mahumood India
0 Suzein Maldives ? Where is Mahumood from India
1 Zameel Pakistan ? Where is Thorig from Pakistan
1 Ashfaq India
2 Ali Umer Maldives
5 Thorig Pakistan

Points to be noted:
* There are players with same name but from diferent countries(yellow,
green and brown)
* There are many players scoring the same number of goals ( highlighted in
pink)
* When I used VLOOKUP it is giving only the first player scoring that
amount of goals
Question is How Can I Do This or Maybe In a better way?


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

Create a PivotTable from your data set. A PT includes a Top N
capability.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
i am a teenage boy and new to this kind of works, so sorry if i am asking a
fulish thing, but i need an answer.
i need to know how i can sort out some datas that are in an excel sheet
AUTOMATICALY
and if it is not possible i need to know how i can do the following one. it
is a football table and i need to know the top scorrers. i have used " rank
for goal and vlookup for players and country" . plaese help me to do this?

All Players Top 05
Goals Player Country S. No Player Country Goals
3 Ashfaq Maldives 1 Sofwan Maldives 6
4 Ali Umer Pakistan 2 Sofwan Maldives 6
5 Thorig India 3 Thorig India 5
6 Sofwan Maldives 4 Thorig India 5
2 Mohamed Pakistan 5 Ali Umer Pakistan 4
6 Mahumood India
0 Suzein Maldives ? Where is Mahumood from India
1 Zameel Pakistan ? Where is Thorig from Pakistan
1 Ashfaq India
2 Ali Umer Maldives
5 Thorig Pakistan

Points to be noted:
* There are players with same name but from diferent countries(yellow,
green and brown)
* There are many players scoring the same number of goals ( highlighted in
pink)
* When I used VLOOKUP it is giving only the first player scoring that
amount of goals
Question is How Can I Do This or Maybe In a better way?


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting