Christ143uk
New Member
- Joined
- Apr 4, 2019
- Messages
- 1
Hi,
So my problem is:
I have a list of 1 million rows of phone numbers
I have a list of 500,000 phone numbers
In both of these lists phone numbers are repeated so I cannot use conditional formatting to highlight duplicates.
Basically I need to highlight any phone numbers/rows in the 1 million lines that also appears in the list of 500,000 phone numbers at least once.
Thanks in advance
So my problem is:
I have a list of 1 million rows of phone numbers
I have a list of 500,000 phone numbers
In both of these lists phone numbers are repeated so I cannot use conditional formatting to highlight duplicates.
Basically I need to highlight any phone numbers/rows in the 1 million lines that also appears in the list of 500,000 phone numbers at least once.
Thanks in advance