|
|
#8
04-11-2022, 03:56 AM
|
|||
|
|||
Ok so I added some more records to the sheet Jobcost so the "Job" number is out of order. This is how our database actually works. This sample data is supposed to represent our database. I have a pivot table on the tab named "PivotTable". I get 2 entries on the pivot table for job 100001. And the forum deleted my images I pasted in.
Do I have to sort the Job column on JobCost sheet before I do a pivot table? I've attached an updated spreadsheet. Thank you! EDIT: Spreadsheet updated here. 
|
| Tags |
| sumif |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround | MCamera | Excel | 1 | 03-02-2022 07:52 PM |
| Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro | Matt C | Excel Programming | 2 | 01-08-2022 06:03 AM |
| Combine "sort within groups" and "identify duplicate/unique values" in two different variables. | civilcervant | Excel | 3 | 06-12-2017 07:27 AM |
| remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
 How to choose a "List" for certain "Heading" from "Modify" tool?
|
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
Windows 10 
Office 2019
Threaded Mode