Mustafa_MageedCopper ContributorMay 16, 2024fill series I want to fill series in a column and skip those cell which has some values (text). and start Again from 1 in the next cell after text
SergeiBaklanMVPMay 16, 2024Mustafa_Mageed If on Excel 365 =SCAN(0, data, LAMBDA(a,v, IF(v="", N(a)+1, v ) ) )
