Array Formula?

Status
Not open for further replies.

Domroy

Board Regular
Joined
Mar 8, 2018
Messages
89
Hi all,

I think I need an Array formula, and I'm not competent with those.

I have two documents I need to compare. Salesforce and KPHC. There are duplicate values

In Salesforce:
CustomerID - Column D
Address - Column U

In KPHC:
Customer ID - Column L
Address - Column E

There ARE duplicates in Customer ID. I'm hoping there's a way to compare Customer ID and address to see if there's an exact match. I'm really struggling with comparing the two...help?
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,095,840
Messages
5,446,817
Members
405,416
Latest member
galoli

This Week's Hot Topics

Top