How do I check for duplicates across multiple worksheets

C

Chrissy

I have six techs that I am tracking invoices and hours billed on said
invoices. I'm trying to figure out how to check for duplicate invoice
numbers (i.e. - double dipping) across the six worksheets.

Is this possible?

Chrissy
 
S

sullasedia

You may form a "pivot table" from your original list and put the "invoice no"
column at the left (row field). When you put the related data at the right
(data items) there will be a line for each invoice. Right click anywhere on
the data items and point field settings. Then click "count" on the given
list. Now you will have the number of invoice rows on your original list.
Auto Filter the headings on the pivot tabe and sellect 2 or greater....

"Chrissy":
 
Top