if missing, then fill in with previous value for multiple columns
Apr 6, 2013 10:58 AM(5875 views)
I'm having trouble getting this logic correct and I'm not sure where I'm going wrong. I want to have a script where, if the operator name is row i is the same as the operator name in row (i-1), then if the measurement value in row i is missing, fill it in with the measurement value in row (i-1). I have several measurement values, so I'm searching across columns for any column with "Meas" in the name.
So far, I have the script below, but it just isn't working and I'm not sure why..
(also, I'm new to the forum. How do I get the code to maintain the formatting when I copy it in?)