Finding last column in range
Please forgive what may appear to be a stupid question, but is there a way to
tell Excel to search in reverse (i.e., right to left) in a formula such as:
=OFFSET(C10,0,MATCH(MAX(C10:N10)+1,C10:N10,1)-1)
In other words, have cell N10 examined first, followed by cell M10, followed
by cell L10, etc.?
Thanks,
Bob
|