Hi, have a look at the attached, column B is =COUNTIF($A$2:$A$29,A2) which you can then filter to show where the count is not 1, column C =IF(B2>1,A2," ") just shows column A where the count is greater than 1.
Let us know if it helps.
HI, as a starting point, LOQ_20200318.xlsxhave a look at the attached, I have added a sheet to show the duplicates. Have a look and let us know what you think. I have added the results to column N on your sample sheet.
Hi, if you click in the cells in “Checksheet” you will see the formula used, another sheet attached, which I tidied a bit and added the conditional formatting, so it looks more like your sheet. Not quite sure I understand your last comment, can you explain a little more of what your trying to achieve.
Hi I have done the first file, across as far as column K(main mailing address), however there are very few duplicates in each category. Don’t know if when I will get chance to do the 2nd file. Had to split 1st in 2 to be able to upload it.