troubleshooting Question

Filling all the non contiguous blank cells in a column with consecutive numbers

Avatar of Dritan Nikolla
Dritan Nikolla asked on
VB ScriptMicrosoft Excel
16 Comments1 Solution584 ViewsLast Modified:
Hi Everybody,

Its first time I am using this website. I have a specific problem I cannot find the solution to anywhere. The data I am trying to fix come from a psychology experiment.

So I have a column of data populated by numbers from 0 to 20. The column has unpredictable blank cells in between those numbers like so:
blank, blank,blank,4,blank,blank,3,blank, blank,blank,blank,5,blankx15, etc

i need to fill all the blanks starting from 0 and incrementing up in each adjacent empty cell up to the next non-empty cell, then move down to the next empty cell and do the same until the end.

This data comes from an application which measures behavioural responses. So each empty cell is a response which the participant was correct, and the cells with numbers are responses which the participant made a mistake, at which point, the total of correct responses is entered into the cell. So the non-empty cell is essentially the sum of all the empty cells above it plus itself.

Thanks a lot.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 16 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros