Alexvez01098Copper ContributorFeb 22, 2020Help with excelHow can i tell excel to take the last value in a column before the “0” that completes the column
SergeiBaklanDiamond ContributorFeb 22, 2020Alexvez01098 If that's the only 0 in the column, it could be =INDEX(A:A,MATCH(0,A:A,0)-1)
