Select the highest value

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
NOT CLEAR.try max function

if the entries are in A1 to A5

=max(a1:a5) give maximum value