Working with sheets in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Everyone!
I have a problem with Excel 2003. I have a sheet of this kind: column
A:Name, column b: country, column c: goals and column d: points. This sheet
has 29 files with information as numbers and texts. I need take the highest
value in the column c and show it in a new sheet. When the value is founded,
by some way the name in the column a has also be showing. Ex. If the highest
value in the column c is in the file 10 this value has to be shown in the new
sheet and the player’s name. How and with which functions can I make this?
 
C2=LARGE(Sheet1!C1:C100,1) ' find largest value
B2=INDEX(Sheet1!A2:A100,MATCH(C2,Sheet1!C2:C100)) ' find name in same row



"Americo" skrev:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria to return maximum value where x = x 3
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Count the columns from one sheet and paste it in another sheet 0
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
need to work across two sheets in excel 2003 3
Vlookup and return sheet name also 2
Need VLOOKUP to Work Two Ways 0
Multiple Conditional tests with Sumproduct 6

Back
Top