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
10 Replies
- 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?
- Yup thanks it worked
