I have a range of cells (B1:B5) that contain random reading values. I want to find the maximum value in that range, and display 'Max' (or a defined number) in the next column, on the same row that the maximum value is located. For example:
B1 = 2 B2 = 4 B3 = 6 C3 = 'Max' B4 = 3 B5 = 1
The maximum value '6' is found in cell B3. I want 'Max' (or a specific number) to be displayed only in cell C3.