Help in Excel

  • Thread starter Thread starter Rajkumar
  • Start date Start date
R

Rajkumar

Hi,
I am new to exceltip & this is my first msg.Say i have the following
values in & as

A1 : 20 ,A5 : 40 ,A7 : 50 ,A12 : 44,A18 : 90 etc......

Now every time i drag/copy-paste the values till the next row.I need to
find out a way so that these values get copied till it finds a value in
the other row(BUT IN THE SAME COLUMN).Like

A1 - A4 :20
A5 - A6 : 40
A7 - A11 : 50
A12 - A17 : 44 &
A18 - 90.

I hope i posted it right.
 
Hi Rajkumar

One way assuming data in A1:A200

1. Select A1:A100 (or enter A1:A100 in the namebox
at the far left of the formula bar)
2. Press <F5> and press the button "Special" (or similar).
3. Choose "Blank cells" (or similar) and OK.
4. Enter =A1
5. Finish with <Ctrl><Enter>

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 
One way (originally from John Walkenbach):

Select column A (click on the A header).

Choose Edit/Goto/Special, select the Blanks radio button and click
OK.

Leaving all the cells selected, type "=" (without quotes), then
up-arrow. Type CTRL-ENTER (not CTRL-SHIFT-ENTER).
 
Back
Top