Forum Discussion
Delete Duplicate Rows With Text Arranged in Different Columns
I have tried to solve your query:
Solution Steps:
1. Firstly i have assigned numbers to each unique person name (in Sheet 1)
2. I have used index and Match function to assign values (in sheet 1) to each cell
3. I add up those values. Now since every person is assigned different values so if sum of values are equal in different rows than they are identical (Persons in rows with same or different positions)
Please check it out
To remove duplicates select data from column A to column R, unselect all, and select only R (or inwhich column you have duplicates).
Cleaning the data is not so easy with formulas. If only generate one more range into which by formulas copy information from initial one substituting it by empty texts for duplicated records.
However, Remove Duplicates shall not change the order of records, it keeps first met record and remove all duplicates which are after it.
Row 1: Apple
Row 2: Apple
Row 3: Orange
After removing duplicates it would look like this:
Row 1: Apple
Row 2:
Row 3: Orange
That is, Row 2 would now be blank instead of deleted.