data analysis problem

**smalllittle** · 03-20-2009, 08:36 PM

I have 2 columns of numbers. I want to divide each number in the first column by the associate number in the second and input results in a new column. Say I have A1:A10000, and B1:B10000, I want C1=A1/B1, C2=A2/B2, C3=A3/B3… C10000= A10000/B10000.
Is that possible to use a function instead of putting each cell at C for 10000 times?

i'm .. new...

**Richard Buttrey** · 03-20-2009, 08:42 PM

Hi,

Why don't you just Edit Copy C1, do an end down on column A to find the last row, move across back to column C, hold the shift key down and do End Up arrow to highlight C10000:C1, then click Edit Paste from the Excel menu.

HTH

**smalllittle** · 03-20-2009, 08:57 PM

Works like magic!!
OK! Now i know if i don't know something I should just ask instead of spending hours googling.....*goes to shoot myself*
Thank you so much Richard.

**mdbct** · 03-20-2009, 09:33 PM

Another method:
Enter the formula in C1
Select C1 if it is not already selected
Double click on the fill handle - the little square on the lower right hand corner of the cell.
Your formula will be copied down to the first gap in rows in the B column.