Serial Numbers

U

uniqxservices

Hi

Have this issue whereby I need to check on certain data on certai
field for repeats. Pls refer below and see if anyone is able to assist
Thanks.

Sheet#1->contains last week's sorted data
Sheet#1
Serial No.
1G15JMWZ12RD
1G15JMWZ12RD
1W1AJMWZF38
1W1AJMWZF328
1S1CJMWZH52
1S1CJMWZH52
1S2CKTTED0A
1S2CKTTED0A

Sheet#2->contains this week's unsorted data
Sheet#2
Serial No.
1G15JMWZ12Rw
1G15JMWZ12RW
1W1AJMWZF38
1W1AJMWZF328
1S1CJMWZH54
1S1CJMWZH54
1S2CKTTED0A
1S2CKTTED0A

Now need to:
1. Compare last week & this week's data, than give an answer if th
same serial number appears again this week.
2. Calculate the total number of times it appeared for both weeks

Thank you
 
B

Bob Phillips

How about this formula in column B on sheet2

=COUNTIF(A1,Sheet1!A:A)

and a similar formula on sheet 1.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

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

Similar Threads

Carry data from sheet to sheet automatically 2
Create filename based on cell contents 7
Import from Access to Excel, via pivot table 1
weekly cash flow template setup - Help! 2
Another VB Code Required 7
Please forgive! 3
Comparing Two Spreadsheets 4
Copy and Paste Help 2

Top