help on filling empty cells

[mojaveboy]

help!!

I have three columns in a spreadsheet which comes from a text file report. Thje first column is name, second column is reference and third column is date. if a client has more than one entry the name and ref only appears agianst the first row for the client ie
REFRENCE NAME DATE
318011 name 28/01/2005
(blank) (blank) 28/01/2005
(blank) (blank) 08/10/2004
(blank) (blank) 08/10/2004

how can I get a formula to add in the missing information

(the text file brings over a lot of other rubbish in between some of the records as well)

cheers

mojaveboy

 

[mojaveboy]

just had a thought... I suppose what I really want to say is that if there is a date in column C then to show the information in colum A if this is blank (using previous completed column A cell)

if that makes sense!!!

 

[Domenic]

Try the following...

1) Select your data

2) Edit > Go to > Special > Blanks > Ok

3) Press =

4) Press the 'Up Arrow'

5) Press CONTROL+ENTER

Hope this helps!

 

[mojaveboy]

thank you

that works

cheers mate!!