I want to be able to have column C return the maximum value whether it be a number or a letter (In the case that there are both the number would be of higher value) for every other column in a row.
I have attached a spreadsheet to help explain the problem further.
Thanks
Bookmarks