dta.mo
New member
Greetings, all, and thanks!
I need to evaluate a range of cells, say A1:AB1, and identify the first cell that is not 0 value. Cells A1:Z1 are all value zero and AA1 is value 10, I need the formula to indicate that the 27th cell is the first non zero. This is to identify the date of first sales for a company.
Likewise, I need to identify the date / cell of last sales for a company in the same cell range.
Thanks!
I need to evaluate a range of cells, say A1:AB1, and identify the first cell that is not 0 value. Cells A1:Z1 are all value zero and AA1 is value 10, I need the formula to indicate that the 27th cell is the first non zero. This is to identify the date of first sales for a company.
Likewise, I need to identify the date / cell of last sales for a company in the same cell range.
Thanks!