I have an Excel spreadsheet with over 400 rows of values from A (lowest Value)B,C,D,E,F,G,H,I,0,1,2,3,4,5,6,7,8,9 (Highest Value) and where current highest value changes frequently (See example). I need to know the highest value in the row. A Max Formula would be perfect but it ignores letter values which MUST be used. What is the simplest way to find the highest value in each row. Also, my skill level with Excel is just a little better than basic so please make your reply as step by step as possible.
Current_Revision.png