Comparing account numbers

H

howard

Well-known Member
Joined
Jun 26, 2006
Messages
6,561
Office Version
  1. 2021
Platform
  1. Windows
I have existing account numbers in Col E on Sheet1 for eg 6X, 1105, 3015, 1107K etc

I have account number that are imported on sheet TB in Col B . I need to compare the account numbers on Sheet1 Col E with the account Number in Col E to determine which new account numbers have been added

Your assistance in this regard is most appreciated
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
For a quick check I would just do a VLOOKUP on Sheet TB and any that return N/A will be new

=VLOOKUP(B2,Sheet1!E:E,1,0)
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
VLOOKUP
2 3
Replies
22
Views
816
Anonymous1378
A
L
  • Solved
Using IF inside FILTER command to modify a value
Replies
1
Views
312
Ludwig
L
himderfella
  • Solved
Do not calculate formula if there are blank cells
Replies
4
Views
509
MARK858
MARK858
B
  • Question
Duration (Time Difference) between 2 date fields in different rows
Replies
3
Views
422
Leo Skywalker
L
D
  • Question
Completely cleaning account numbers and storing with a specific format
Replies
2
Views
599
diversification
D

Forum statistics

Threads
1,214,667
Messages
6,120,818
Members
448,990
Latest member
rohitsomani

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top