Serial Numbers

  • Thread starter Thread starter uniqxservices
  • Start date Start date
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
 
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)
 
Back
Top