Related:
- Excel help needed
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
1 response
1) Insert a column by which you will create an index to sort by (just numbering each row with a unique id, 1, 2, 3, etc)
2) Sort by the column that contains the offending repeaters
3) Insert one more column
4) Use an if statement as follows: =if(a1=a2,"*","") in the first cel. Copy through all cells in that column.
Assuming cell a1 is the first cell in the column that contains the offending repeaters, otherwise change it to the correct cell. This flags all repeating columns with an asterisk, leaving the first cell as an original copy, unflagged.
5) Use the filter tool in the column that contains the above formula. Press the chevron to show the astersk and select it.
6) Delete all rows which are exposed, or atleast the rows of the offending repeaters.
Remove the filter.
Delete the column containing the folrmula.
Restore original sort by sorting by the column created in step 1
Delete the column containing the index created in step 1.
Done.
I usually do this process in a separate worksheet that I copied the original worksheet from, just in case human error prevails!
2) Sort by the column that contains the offending repeaters
3) Insert one more column
4) Use an if statement as follows: =if(a1=a2,"*","") in the first cel. Copy through all cells in that column.
Assuming cell a1 is the first cell in the column that contains the offending repeaters, otherwise change it to the correct cell. This flags all repeating columns with an asterisk, leaving the first cell as an original copy, unflagged.
5) Use the filter tool in the column that contains the above formula. Press the chevron to show the astersk and select it.
6) Delete all rows which are exposed, or atleast the rows of the offending repeaters.
Remove the filter.
Delete the column containing the folrmula.
Restore original sort by sorting by the column created in step 1
Delete the column containing the index created in step 1.
Done.
I usually do this process in a separate worksheet that I copied the original worksheet from, just in case human error prevails!
Jan 8, 2009 at 01:44 PM