I'm looking to compare the value of the max score of a group of people, format is as follows:
date user1 user2 user3
06/07/2011 123 112 244
How do I determine which of values on the row is the highest? Eg, I would like to pull 244 from this row.
How about using the max-function?
Use the max function in whatever cell you want it in:
=Max(A2:A4)