dragging formula

[shrutikhurana]

Hi...

if i want to drag a formula across a spreadsheet...picking up sa
M4,M5,M6....& so on from another website...how do i that. whenever
drag it pics up M4,N4,O4...and so on. i want it to go down

please hel

 

[Peo Sjoblom]

One way

=INDEX($M$4:$M$1000,COLUMNS($A$1:A1))

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"shrutikhurana" <[email protected]>
wrote in message
news:[email protected]...

 

[shrutikhurana]

thanks so much...