Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finction to find the first cell that is not zero
Hi
I want to find the first cell that is not zero "0" across a row. I am also trying a VBA solution, but is ther percahnce a function that will do this? Mark |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finction to find the first cell that is not zero
On Sat, 9 Jun 2007 06:08:46 +1000, "Mark" wrote:
Hi I want to find the first cell that is not zero "0" across a row. I am also trying a VBA solution, but is ther percahnce a function that will do this? Mark What do you mean by "find" the first cell? This **array-entered** formula will return the column number of the first cell in row 1 with a non-zero entry (enter with <ctrl-shift-enter) =MATCH(1,ISNUMBER(1:1)*(1:1<0),0) This **array-entered** formula will return the value in that cell: =INDIRECT(ADDRESS(1,MATCH(1,ISNUMBER(1:1)*(1:1<0) ,0))) --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finction to find the first cell that is not zero
Sat, 9 Jun 2007 06:08:46 +1000 from Mark
: I want to find the first cell that is not zero "0" across a row. I am also trying a VBA solution, but is ther percahnce a function that will do this? Please don't post the same query multiple times. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finction to find the first cell that is not zero
Hi Ron
Thanks for this, it has solved another issue that I have just stumbled across with my data. Cheers... "Ron Rosenfeld" wrote in message ... On Sat, 9 Jun 2007 06:08:46 +1000, "Mark" wrote: Hi I want to find the first cell that is not zero "0" across a row. I am also trying a VBA solution, but is ther percahnce a function that will do this? Mark What do you mean by "find" the first cell? This **array-entered** formula will return the column number of the first cell in row 1 with a non-zero entry (enter with <ctrl-shift-enter) =MATCH(1,ISNUMBER(1:1)*(1:1<0),0) This **array-entered** formula will return the value in that cell: =INDIRECT(ADDRESS(1,MATCH(1,ISNUMBER(1:1)*(1:1<0) ,0))) --ron |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finction to find the first cell that is not zero
On Tue, 12 Jun 2007 10:58:14 +1000, "Mark"
wrote: Hi Ron Thanks for this, it has solved another issue that I have just stumbled across with my data. Cheers... You're welcome. Glad to help. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
How to use trim finction in array | Excel Worksheet Functions | |||
putting in a sum finction | Excel Discussion (Misc queries) | |||
Change the appearance cell where Find criteria is found in a cell | Excel Discussion (Misc queries) | |||
how do you find a cell equal to a cell from another list | Excel Discussion (Misc queries) |