- Joined
- 21 Mar 2002
- Messages
- 1,693
Hi,
I've got an excel spreadsheet full of data that I have compiled from 3 other spreadsheets. A lot of the data in these spreadsheets are present in all 3, so now the one large file I have contains duplications of certain lines.
Is there anyway to run some sort ot batch process or script that will remove any extra instances of every row of data other than the first occurance of the data in that row?
Thanks in advance!
I've got an excel spreadsheet full of data that I have compiled from 3 other spreadsheets. A lot of the data in these spreadsheets are present in all 3, so now the one large file I have contains duplications of certain lines.
Is there anyway to run some sort ot batch process or script that will remove any extra instances of every row of data other than the first occurance of the data in that row?
Thanks in advance!