Help!

M

mmissjanet

I want to compare two columns but they are not in the same order. I wan
to see if there are matching numbers in the two columns and they are o
two different worksheets. Here is a sample of what I have.

WORKSHHET 1:
LAST_NAME FIRST_NAME BTN
DWIGHT MILLER 5085590345

WORKSHEET 2:
BTN Account Number Customer Name
5082954804 3900194 MARY ANNE SILVA

The colums are different and the names are not in the same order. Wha
I want to do is find the BTN numbers that are the same and the one
that are different.

Can anyone help
 
T

trickdos

You can use an Index and Match to help with this and search if number
are on a list
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top