Fill Down

T

T De Villiers

Hi I have a list:

cell a1:J1
CELL A2:J1
CELL A3: (bLANK)
CELL A4: J2
CELL A5: (BLANK)
A6: J12
A7: J12
A8: J12
A9: (BLANK)
ETC.ETC.


I have 2000 rows of this nature,
I need a fill down so that in the above for example A3 WILL BE J1, A
WILL BE J2 and A9 will be J12.
etc.

Thank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to delete ALL cells containing the same data 1
Remove specific cells in a column. 2
How to delete ALL cells containing the same data 0
How to delete ALL cells containing the same data --- REVISED 0
remembering the same filtering criteria 13
Copy Matching Numbers To New Cell's 5
LOOPING BUT THE MARKS ARE NOT IN SEQUENTIAL ORDER 4
Average Question 2

Top