Highlight duplicate data blocks
Hi all,
I have a large data sheet made of 8 columns (A:H) and over 45000 rows.
Data are sorted into sets of variable number of rows. Each set of data is separated from the following with one blank row.
I am in need to highlight duplicate data blocks/sets. Duplicate data blocks have to be identical in everything: the number of rows per each set and data content per row and column of that data block.
I spent a long time searching for a similar answered question, but in vain.
Can I get some assistance with this question, please?
More than appreciating ..
M.