How do I flag duplicate data in 2 separate Excel files

[pem089]

I have a report that I have to run every week and one of the main list name is called "order number" and lists various order numbers in that column. I need to somehow be able to determine if that order number was on the previous report or subsequent reports. What is the best way that I can flag the reports for this information.

Thanks much!!

Pem089

 

[John Davis]

I have a report that I have to run every week and one of the main list name is called "order number" and lists various order numbers in that column. I need to somehow be able to determine if that order number was on the previous report or subsequent reports. What is the best way that I can flag the reports for this information.

Thanks much!!

Pem089

I would suggest you take a look at the VLOOKUP Function and see if you can apply that.

 

[Yahya]

try this

Excel Workbook
	A	B
1	Order Number
2	Order 1	Duplicate
3	Order 2	Duplicate
4	Order 3	Duplicate
5	Order 4	Duplicate
6	Order 5	Duplicate
7	Order 6	Duplicate
8	Order 7	Duplicate
9	Order 8	Duplicate
10	Order 9	Duplicate
11	Order 10	New
12	Order 11	New
13	Order 12	New
14	Order 13	New
15	Order 14	New
Sheet1

Excel 2007

Cell Formulas
Range	Formula
B2	=IF(ISNUMBER(MATCH(A2,Sheet2!$A$2:$A$10,0)),"Duplicate","New")

then other sheet

Excel Workbook
	A
1	Order Number
2	Order 1
3	Order 2
4	Order 3
5	Order 4
6	Order 5
7	Order 6
8	Order 7
9	Order 8
10	Order 9
Sheet2

Excel 2007

 

[pem089]

Yahya,

Thank you so much!! I will try it and let you know. Have a great day!!

PEM089