Help with excel

[Alexvez01098]

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

[#2]

@Alexvez01098 

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

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

[#3]

Yup thanks it worked

[#4]

What if there’s a zero before in the column?

[#5]

@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?

[#6]

I dont know how to use this one

[#7]

@Alexvez01098 

In simplest case that's like

[#8]

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

[#9]

@Alexvez01098 

Perhaps you may submit sample file removing sensitive information? Is it something after last zero, is that text or number, etc. ?

[#10]

I want excel to take the last info before all the zero at the end

[#11]

@Alexvez01098 

That is another model

formula is

=INDEX(A:A,AGGREGATE(14,6,1/($A:$A=0)/(LEN($A:$A)>0)*ROW($A:$A),1)-1)