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
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