Select the highest value

Closed

Maura - Sep 10, 2010 at 12:42 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 12, 2010 at 07:46 AM

Hello, I can really use some help here. I have four sets of numbers in an Excel spreadsheet, representing the same item, taken over a period of time. Is there a formula which will compare all four and select the highest. Once that number is in another cell, I can use the paste value to capture and utilize it in a graph. Thanks so much for your help.

Select the highest value
Vba select case like - Guide
Lg tv setting select mode - Guide
Clear only the formatting from the selected cell (leaving the content) - Guide
Press f1 at power-on. select startup - Guide
What are the key functions of the supportassist for home pcs? (select 2) - Download - Cleaning and optimization

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 12, 2010 at 07:46 AM

NOT CLEAR.try max function

if the entries are in A1 to A5

=max(a1:a5) give maximum value

Similar discussions

Why can't I bridge connect?

Nfs most wanted 2005 shows "please insert the correct CD

Please Insert the correct CD-ROM

Can't select text

select a proper boot device or insert boot media

Similar discussions

Subscribe To Our Newsletter!