Search : in
By :

Simple Excel Question (I think)

Last answer on Nov 5, 2009 2:45:22 pm GMT ruh-roh, on Nov 3, 2009 9:35:56 pm GMT 
 Report this message to moderators

Hello,
I am putting together an XL sheet and would like to find the MAX value in a column of numbers, then return the contents of the cell next to it. For example, out of 10 test scores (cells B1 through B10), I would like to first identify the highest score, then look in Column A for the name of the student the high score belongs to, then display the student's name in cell C1. Any suggestions on how to accomplish this would be very much appreciated. Thanks!

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Simple Excel Question (I think) » in :
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Download DBF to Excel Converter ShowDescription The application is designed by WhiteTown Software. DBF to Excel is a tool that allows you to convert your file easily. Simple and easy to use, the application has been awarded from various places. Offering an intuitive interface, the...
Download DC Simple Calendar ShowBy default, Windows do not consist of calendar. However Outlook Microsoft has an agenda where you can note dates or of think of animals. But to have a calendar in full measure, it is necessary to install gadgets or other tools of type. DC Simple...
Download XLS (Excel) to DBF Converter ShowDescription The application is designed by WhiteTown Software. XLS (Excel) to DBF Converter is a tool that enables you to convert your XLS files to DBF format quickly and easily. Simple and easy to use, the application has been awarded from various...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

venkat1926, on Nov 5, 2009 11:17:03 am GMT

=INDIRECT("A"&MATCH(MAX(B1:B10),B1:B10,0))

if necessary modify the macro

   
Reply to venkat1926

2

 ruh-roh, on Nov 5, 2009 1:32:05 pm GMT

Sweet! Thnaks very much -- this really helps out!

   
Reply to ruh-roh
Ask your question Reply
They need your help