Forum Discussion
Multiple Values
I have a vertical column with about 1000 addresses' is there any way to show if any address is mentioned multiple times and number of times it appears?
1) Select the column.
On the Home tab of the ribbon, click Conditional Formatting > Highlight Cells Rules > Duplicate Values... and then click OK.
Duplicates will be highlighted in red.
2) To count the number of duplicates:
Let's say the addresses are in column A, starting in A2.
Enter the following formula in B2, then fill down:
=COUNTIF(A:A,A2)