Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what formula in Excel will identify the first zero in a row and...
A row contains a series of diminishing numbers. I am looking for a formula
to identify the first zero occuring in the row and return the date contained in the same column but higher row. Any help is appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what formula in Excel will identify the first zero in a row and...
try where the 0 is found in row 18 =INDEX(17:18,1,MATCH(0,18:18,0)) -- Don Guillett SalesAid Software "Dawnstar253" wrote in message ... A row contains a series of diminishing numbers. I am looking for a formula to identify the first zero occuring in the row and return the date contained in the same column but higher row. Any help is appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what formula in Excel will identify the first zero in a row and...
Here is an example with rows 8 and 9
=INDEX(8:8,,MIN(IF(9:9=0,COLUMN(9:9)))) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dawnstar253" wrote in message ... A row contains a series of diminishing numbers. I am looking for a formula to identify the first zero occuring in the row and return the date contained in the same column but higher row. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions |