| | | | | | | | find the last nonzero number in column H that may contain numbers as well as text entries | spreadsheet locale | question in Google Docs user forum by Mike Ladouceur |

| | | | | | | | 1100 | United States | |

| | | | | | | 0 | | |

| | | | | | | 1000 | | this is cell J4 |

| | | | | | | 1200 | | formula in cell I2 |

| | | | | | | 0 | | =arrayformula(index(filter(H3:H,(H3:H<>0)*(isnumber(H3:H))),count(if( H3:H <>0,H3:H)))) |

| | | | | | | 0 | |

| | | | | | | | | or |

| | | | | | | 0 | | =arrayformula(index(query((H3:H+0),"select* where Col1 is not null and Col1<>0 "),count(if(H3:H<>0,H3:H)))) |

| | | | | | | 0 | |

| | | | | | | | | | |

| | | | | | | k | | | |

| | | | | | | p | | | |

| | | | | | | | | | |

| | | | | | | 1100 | | | |

| | | | | | | 0 | | | |

| | | | | | | 0 | | | |

| | | | | | | x | | | |

| | | | | | | c | | | |

| | | | | | | j | | | |

| | | | | | | c | | | |

| | | | | | | j | | | |

| | | | | | | c | | | |

| | | | | | | j | | | |

| | | | | | | c | | | |

| | | | | | | n | | | |

| | | | | | | | | | |

| | | | | | | | | | |

| | | | | | | | | | |

| | | | | | | | | | |