Copy numbers to fill in blanks

Originally Posted by shdwfx

I'm getting results of all zeros.??

I worked out why this happened - if row 1 of the selected column is blank, this will give all zeroes. There are two ways round it - either select only the range needed (A3 to A50, or whatever) or put something into row 1 temporarily (like 'xyz', do the F5→Special→Blanks→=→Up→Ctrl-Enter trick, then delete the temporary text.

I know you don't need this info now, but maybe it'll be of use to someone...

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.