String Searching

[arapone]

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.

 

[arapone]

ok.. fixed that, and it seems to work. Now the only problem is sometimes there is a 0 listed (and thats number 0), which would be the intial revision. When that ends up being the latest revision, the result is #N/A.

 

[Oaktree]

Format the cells as text first, then enter your 0 (or enter them as '0 with the quote text qualifier)

The formula works with text formatted 0's, but gives #N/A's with number formatted 0's.

 

[arapone]

perfect. Thanks a million !