| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Highlighting Data
Suggest your best bet is a pivot table. I'd put Plant in the first column, Part No along the top, and Count of parts on the interior data portion of the table. (If Excel suggests Sum of Part Numbers when you drag the Part No button to the data area, double click it & you can change it.) This woo produce a table of Part Numbers with a tally of number of each produced at each Plant as follows: Count of Plant Plant Part A B C D Grand Total abc123 1 1 2 abc234 1 1 abc456 1 1 abc567 1 1 abc678 1 1 2 abc789 1 1 abc890 1 1 1 1 4 Grand Total 3 3 3 3 12 ---Glenn -- gjcase ------------------------------------------------------------------------ gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=522793 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Importing Data | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Threaded Mode
