Search : in
By :

Finding max number but displaying text name

Last answer on Oct 28, 2009 2:23:04 am GMT amature, on Oct 27, 2009 4:49:17 pm GMT 
 Report this message to moderators

Hello,
Ok, I am trying to find the highest number (max) in all the cells between B1:B100 when it finds that max number I then want it to grab the Name out the cell next to it, cells A1:A100 and display the name not the number. I'm having a brain fart here. who has the easy answer? And thank you.

Configuration: Windows XP Internet Explorer 7.0

Best answers for « finding max number but displaying text name » in :
Restrict display user name on login screen Show Restrict display user name on login screen Under Windows XP, if you log on classic session without the welcome screen, the open window will request the username and password. As default, the name of the last user of the computer will...
Convert number to text in excel sheet Show
Displaying your name on the taskbar near the clock Show Displaying your name on the taskbar near the clock The registry The values to be changed Logos Restart the process: explorer Despite the many personalization solutions for windows, sometimes heavy and demanding resources for less...
How to change XP Serial/License number ShowHow to change XP Serial/License number Go to / Start Menu/ Run/ Type regedit and click OK. Before any operation in the registry, he should make a backup of the registry as a precaution In the Registry Editor, click File...
How to easily display PHP/HTML codes in your webpages ShowHow to easily display PHP/HTML codes in your webpages Issue What code to use? Issue If you want your visitors to be able to see the source codes of your webpage, there is a very easy way to do so. Normally, all you have to do in a...
Viewing connections in real time ShowViewing connections in real time Linux Windows Linux Under Linux, to view your outgoing network connections in real time, open a terminal and type the following commands: sudo watch lsof-i It will display: The name of the...
Linux - User management ShowFirst step for the administrator When several people have access to a system, the administrator must manage the users. To do so, he must know the common commands and files to be configured. The important files are: the /etc/passwd file the...
UNIX - Files ShowIntroduction to UNIX files In UNIX systems any element is represented in the form of a file. All files are architectured around a single tree structure where the base, called the root, is written "/". File types UNIX systems define different...
CSS - Style sheets ShowFont properties Property Value Description font-family Specific font (Arial, Times, Verdana) Familly (serif, sans-serif, fantasy, monospace, cursive) Defines one or more font names or font families. If multiple fonts are defined,...
Ask your question Reply

1

 venkat1926, on Oct 28, 2009 2:23:04 am GMT

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

   
Reply to venkat1926
Ask your question Reply
They need your help