Alright, I am not the most proficient excel user, but do have some decent knowledge of the program and functions. I am having difficulty with one particular search. I want to look up the greatest value in a row and display that value in a particular cell. The row can contain any letter from A-Z and as well - when a value is non-applicable. How can i do a search to display the highest value? I have tried using if statements going greater to and so forth, but its getting quite ridiculous when in certain applications, there are 50+ rows to search.