Hi,
I'm looking for a formula that will identify duplicate data from multiple columns. The format should only apply if each of the data in the selected columns are duplicated in subsequent rows. In the attached data set, Columns A, B, and E are the critical information that define a "duplicate". Some other data in the columns are duplicates, but not mutually exclusive. The conditions should dictate:
"If the data in columns A, B, and E are duplicated in subsequent rows, then highlight the rows where this information occurs"
Bookmarks