| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Ranges using non-contiguous cells and dependent on a cell value | Excel Worksheet Functions | |||
| Non updatable Unique Random Number | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Finding a range from a column using VBA. | Excel Worksheet Functions | |||
Threaded Mode
