Jul 07 2020 11:26 AM
So if anyone can help , I want to find the last number in a column. Sometimes the last cell is blank and when that happens I would want that last blank cell to be a zero. Maybe some kind of IFERROR formula?
Jul 07 2020 03:04 PM
Depends what do you mean under the column, if some range that could be like
=INDEX(A1:A80,AGGREGATE(14,6,1/(ISNUMBER(A1:A80)+ISBLANK(A1:A80))*ROW(A1:A80),1))
Jul 07 2020 06:17 PM