Forum Discussion
autofill gaps in download list in excel with information from cells above
Hello I am struggling to remember how to autofill a list. Please see below. This is a dump of information. I am trying to autofill the gaps with the data from the cells above. Is there a quick way t...
The Go To Special solution offered is the best approach.
If one must have a formula and working in 365:
=SCAN("",A1:A50,LAMBDA(a,v,IF(v="",a,v)))