asked on Needed Tested Method for Highlight Duplicates
Needed Tested Method for Highlight Duplicates
If cells A1+B1 are the same as A2+B2, I would like to highlight all the instances that are duplicated.
In this case, A2+B2 would be highlighted but A1+B1 would not, since they are the first occurrence.
This needs to happen in a Google Spreadsheet.
I have made a sample
https://docs.google.com/spreadsheets/d/1vnTWNv-elPciIlYsKOV7Z_fiffS1D4TMUrY5ilk6rPc/edit#gid=1733025047
Assistance is greatly appreciated.
If cells A1+B1 are the same as A2+B2, I would like to highlight all the instances that are duplicated.
In this case, A2+B2 would be highlighted but A1+B1 would not, since they are the first occurrence.
This needs to happen in a Google Spreadsheet.
I have made a sample
https://docs.google.com/spreadsheets/d/1vnTWNv-elPciIlYsKOV7Z_fiffS1D4TMUrY5ilk6rPc/edit#gid=1733025047
Assistance is greatly appreciated.
GoogleSpreadsheetsMicrosoft ExcelMicrosoft Office
Last Comment
Martin Nguyen
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Are there any examples of A1+B1 being the same as A2+B2? In the sheet you shared it does not appear any rows meet that criteria.