"imagine" I have a spread sheet which has for example 5 lines of text exactly the same, then another five lines exactly the same, and so on.
I want to to show all the lines of text ONLY ONCE, for example I want to be able to take out all the duplicate lines of text. If there was 50 lines with only 10 lines different, which is the easiest way to revove all duplicate lines without having to delete them manualy. I thought there was some kind of formula which you could ask if rows apear the same then delete all of them leaving only one line,so I would end up with 10 lines all different.
I have been driving myself mad over this one, and I am sure someone will make my day and save me hours of work.
I hope you can help, if you resolve this for me I will be the happiest man allive (sad aint I LOL)
Cheers XX
2007-02-18
10:06:06
·
4 answers
·
asked by
Stumpy247
1