hi,
i have an item list on excel. 42k rows and 15 columns.
alot of items have been listed twice and some even thrice. as the product is same but the seller is different.
what i want to do is check only 8 columns (a,b,c,d,f,h,i,k) to decide if the row is duplicate or not. if it is has an exact match with another row for the respective 8 columns, i want to cut paste both/all the matching rows into the next sheet (all 15 columns), where i can manually merge/delete/seperate depending on the item
i have an item list on excel. 42k rows and 15 columns.
alot of items have been listed twice and some even thrice. as the product is same but the seller is different.
what i want to do is check only 8 columns (a,b,c,d,f,h,i,k) to decide if the row is duplicate or not. if it is has an exact match with another row for the respective 8 columns, i want to cut paste both/all the matching rows into the next sheet (all 15 columns), where i can manually merge/delete/seperate depending on the item