Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COMBINING CELLS WITH LIKE DATA
I HAVE A SPREADSHEET TO TRACK INTERNAL MACHINING SCRAP SIMILAR TO THE ONE
BELOW. I AM LOOKING FOR A WAY TO INSTANTANIOUSLY COMBINE ALL THE TOTALS FOR CUSTOMER A OR PART 13112 OR MACHINE B9 ON ANOTHER SPREADSHEET IF ANYONE KNOWS OF A WAY TO DO THIS PLEASE LET ME KNOW. THANKS. DATE CUSTOMER PART MACH # QTY TOTAL 8/9/2004 A 111 B9 2 13.46 8/9/2004 S 123 B9 4 26.92 6/4/2004 S 123 C14 5 31.95 6/1/2004 M 2131 C14 12 29.88 7/22/2004 B 13123 C3 1 0.75 7/5/2004 A 12312 C4 1 0.75 7/5/2004 A 12312 C4 1 0.75 8/24/2004 S 41 A1 1 0.75 8/23/2004 X 14214 A2 1 0.75 8/6/2004 T 1412 C15 1 43.78 6/8/2004 Y 1221 C15 1 43.78 |
#2
|
|||
|
|||
I think I'd us a Pivot Table for that.
Let us know if you need help setting it up. -- Regards, Ron |
#3
|
|||
|
|||
WORKS GREAT
THANKS "Ron Coderre" wrote: I think I'd us a Pivot Table for that. Let us know if you need help setting it up. -- Regards, Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Data | Excel Discussion (Misc queries) | |||
How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
Help adding text values | Excel Worksheet Functions | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |