Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working with sheets in Excel 2003
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 players name. How and with which functions can I make this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working with sheets in Excel 2003
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: 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 players name. How and with which functions can I make this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 macro not working in Excel 2003 | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Lotus transition not working in Excel 2003 | Setting up and Configuration of Excel | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 - Sort Sheets | New Users to Excel |