P
punter
Hi again,
This is a follow up to my last post (thank you for your quick replies)
Does anyone know of an "auto fill" formula along the lines of a sum i
formula? If I have a column of data with blanks how do I get the shee
to fill in the blanks with the first cell above that contains data?
Example: If A2 has a "1" in it and there are blanks from A3 to A10 an
a "2" in A11 with blanks from A12 to A20,how do I get excel to count th
A3 to A10 blanks and fill in the "1" from above, then count A12 to A2
and fill in the "2" from A11? Any thoughts?
Thank
This is a follow up to my last post (thank you for your quick replies)
Does anyone know of an "auto fill" formula along the lines of a sum i
formula? If I have a column of data with blanks how do I get the shee
to fill in the blanks with the first cell above that contains data?
Example: If A2 has a "1" in it and there are blanks from A3 to A10 an
a "2" in A11 with blanks from A12 to A20,how do I get excel to count th
A3 to A10 blanks and fill in the "1" from above, then count A12 to A2
and fill in the "2" from A11? Any thoughts?
Thank