View Single Post
 
Old 09-22-2014, 07:13 AM
thetraininglady thetraininglady is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

Ok because you've used AutoFill to copy the formula from A3 across to B3, C3, etc it hasn't worked because it's now referencing H2, I2 etc which do not have any values in them. So you need to change the formula in B3 to be =A3+1 and then AutoFill B3 across the row.
Reply With Quote