Claire has attended:
Excel Intermediate course
Microsft Excel
I import a list of accounts and data into a spreadsheet on a monthly basis and, often, lines are repeated and information is duplicated from the system and it takes a long time for me to find and delete the extra rows. Is there an easy way of identifying duplicate information within a spreadsheet?
RE: Microsft Excel
Hi Claire
Thanks for your question. I have an idea, however for this to work, each column of data has to have a heading at the top of the column.
Try the following:
1. Import the data into a blank sheet.
2. Go to the Advanced filter option in Excel (Data-Filter-Advanced filter).
3. Choose to filter the list, in place and tick the box that says Unique records only. Then click OK.
4. This should omit any duplicated rows of information.
5. Copy and paste the results of the filter into the spreadsheet they need to go in.
I hope this helps to save you some time.
Amanda
RE: Microsft Excel - advanced filtering
Hi, thanks for the reply.
I hope you dont mind but I forwarded your response to my mum (who has been having the problem) and this is her response.....
Hi Claire
Jackie and I have been trying to filter our spreadsheet using the suggestion from your forum, but it's not working.
I think the problem may be that the data is imported as a text file, which we can use in Excel, (but only if we save it as a Microsoft Excel file first). I'm wondering if that is affecting the filtering function in some way?
You know most files open in Excel with .xls at the end; this file opens with .csv at the end. In my version (Excel 97) it says the type of file is 'Text (Tab delimited)'. In Jackie's version (Excel 2000) it says the file type is 'Unicode Text' - both versions open as a .csv file.
Any more suggestions?
