Duplicates

Find, highlight and remove duplicates in Google Sheets: the Remove duplicates menu compared with UNIQUE, COUNTIF rules for whole rows, and two lists compared. Every formula tested.