Forum Discussion
Help with excel
How can i tell excel to take the last value in a column before the “0” that completes the column
What if there’s a zero before in the column?
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?
- 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
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)Perhaps you may submit sample file removing sensitive information? Is it something after last zero, is that text or number, etc. ?
- I want excel to take the last info before all the zero at the end
- I dont know how to use this one