Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >
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 ) ) )