Is there a formula to do the following:-



Sheet 1: Column C say, rows 3 to 8 have the values 4, 6, 5, 2, 3 and 1

I would like to capture in Sheet 2: the maximum of the above 6 values

Thank you

Bob M