Forum Discussion

Copper Contributor

Feb 22, 2020

Help with excel

How can i tell excel to take the last value in a column before the “0” that completes the column

Formulas and Functions

Diamond Contributor

Feb 22, 2020

If that's the only 0 in the column, it could be

=INDEX(A:A,MATCH(0,A:A,0)-1)

Alexvez01098
Copper Contributor
Feb 22, 2020
What if there’s a zero before in the column?
- SergeiBaklan
  Diamond Contributor
  Feb 22, 2020
  Alexvez01098
  
  It returns the value before first found zero. Why do you use zero as column end, not COUNTA() to calculate the size of the range in the column?
  - Alexvez01098
    Copper Contributor
    Feb 22, 2020
    I’m using it to find a time zone descrition. Some of the zone value is 0. I need it to find the last value in my colum before the last zero
Alexvez01098
Copper Contributor
Feb 22, 2020
Yup thanks it worked

Resources