| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I check for duplicates across multiple worksheets
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I check for duplicates across multiple worksheets
Chip has lots of stuff on duplicates - www.cpearson.com
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Chrissy" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I check for duplicates across multiple worksheets
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": 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line chart from multiple worksheets | Charts and Charting in Excel | |||
| Adding and Naming Multiple Worksheets | Excel Worksheet Functions | |||
| how do I arrange multiple worksheets from the same workbook | Excel Discussion (Misc queries) | |||
| Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
