| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
function - find first number in row 0, return cell column number
{=MATCH(CELL("col"),C2:H20,0)} I'm trying to get the column number of the first cell in a row that has a value 0. I been trying things like above, but, I have been crushed. Please help. Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
function - find first number in row 0, return cell column number
On Apr 19, 12:23*pm, cate wrote:
{=MATCH(CELL("col"),C2:H20,0)} I'm trying to get the column number of the first cell in a row that has a value 0. I been trying things like above, but, I have been crushed. Please help. *Thank you. monkey monkey monkey... got it :-) Gets the column offset and I add it to find another cell. {=INDIRECT(ADDRESS(1,MATCH(TRUE,(B3:H3)0,0)+CELL( "col")))} Now to figure out how to ignore cell values which are not proper numbers. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
function - find first number in row 0, return cell column number
On Apr 19, 1:31*pm, cate wrote:
On Apr 19, 12:23*pm, cate wrote: {=MATCH(CELL("col"),C2:H20,0)} I'm trying to get the column number of the first cell in a row that has a value 0. I been trying things like above, but, I have been crushed. Please help. *Thank you. monkey monkey monkey... got it *:-) Gets the column offset and I add it to find another cell. {=INDIRECT(ADDRESS(1,MATCH(TRUE,(B3:H3)0,0)+CELL( "col")))} Now to figure out how to ignore cell values which are not proper numbers. Nope.... doesn't wok. I get a A2 address but indirect treats it sometimes like a ref to a ref, other times a ref to a value. !@# |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
function - find first number in row 0, return cell column number
Hello Cate,
Perhaps something like this array formula: =MATCH(1,ISNUMBER(B3:H3)*(B3:H30),0) +COLUMN(B3)-1 cate a écrit : On Apr 19, 1:31*pm, cate wrote: On Apr 19, 12:23*pm, cate wrote: {=MATCH(CELL("col"),C2:H20,0)} I'm trying to get the column number of the first cell in a row that has a value 0. I been trying things like above, but, I have been crushed. Please help. *Thank you. monkey monkey monkey... got it *:-) Gets the column offset and I add it to find another cell. {=INDIRECT(ADDRESS(1,MATCH(TRUE,(B3:H3)0,0)+CELL( "col")))} Now to figure out how to ignore cell values which are not proper numbers. Nope.... doesn't wok. I get a A2 address but indirect treats it sometimes like a ref to a ref, other times a ref to a value. !@# |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a number in a column then return a value from another cel | Excel Worksheet Functions | |||
| Function that will look at letter in a column and return a number | Excel Worksheet Functions | |||
| find lowest number and return it's adjacent cell | Excel Worksheet Functions | |||
| Find max number of character and return cell address | Excel Worksheet Functions | |||
| return the column reference number of a function result | Excel Discussion (Misc queries) | |||
Hybrid Mode
