Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Column number of last column containing a number
Trying to figure a formula that will give me the column number of the last
column with data in a range. This is a sliding entry row where there may be blanks at the begining and middle of the range. Range is b26:m26 and may be as below: 0 0 1 1 0 1 1 0 0 0 0 0 I am looking to get colum 8 for use in an OFFSET lookup to other data in the column. I have tried no end of some of the suggested formulas in this forum but have not gotten there yet. Thank you -- Karl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find the largest number in column | Excel Discussion (Misc queries) | |||
how to set up a column in excel so it can auto number | Excel Discussion (Misc queries) | |||
How do I sort a column a unique number? | Excel Worksheet Functions | |||
Write formula to add "1" to each number in a column | Excel Worksheet Functions | |||
how do I find an average number of specific words in a column | New Users to Excel |