Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

Frequitude · 01-20-2011, 02:07 PM

It'll take 2 minutes!

Do, say 50 cells per column. So 0-49 on the left, 0-50-100-...-8450 on the top. Copy, paste, done.

Edit: the 0-50-100-...-8450 part can be done easily by just doing the cell to the left plus 50, and copying that formula to the right. Sorry if you knew that, not sure how comfortable in excel you are.

01-20-2011, 02:07 PM	#14
Frequitude Franchise Player Join Date: Jul 2005 Location: 555 Saddledome Rise SE Exp:	It'll take 2 minutes! Do, say 50 cells per column. So 0-49 on the left, 0-50-100-...-8450 on the top. Copy, paste, done. Edit: the 0-50-100-...-8450 part can be done easily by just doing the cell to the left plus 50, and copying that formula to the right. Sorry if you knew that, not sure how comfortable in excel you are. Last edited by Frequitude; 01-20-2011 at 02:10 PM.