Help!

  • Thread starter Thread starter mmissjanet
  • Start date Start date
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
 
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

Back
Top