How do I check for duplicates across multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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":
 
You must log in or register to reply here.

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

Access Access variable string for export 0
How do I find like data in multiple worksheets? 1
How can I create a running yearly total for all of my invoices? 1
Checking for Duplicates within a Workbook 7
HOW DO I DUPLICATE SHEET TO BOOK??? 2
Linking Totals Across Multiple Worksheets 2
auto add data with addition of new worksheets 5
BIFF - Help!! lookup numbers in multiple columns and return one nu 6

Back
Top