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.



1 response

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
0