Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with a table
HI all, I have a spreadsheet dealing with pallets that come into the company I work for. On each pallet there may only be one model or many different models with varying quantitys. 16 R874SLM 6 R874WM 5 R872SLM 1 R754SLM 3 R765SLM 1 17 R953SLM 8 R95STM 1 R774WM 1 R754SLM 1 R884SLM 1 R872SLM 1 R343GM 1 R96STM 2 18 R957SLM 12 R95STM 1 R383SLM 1 R345SLM 1 R771GM 1 19 R84STM 13 R85STM 4 R754SLM 2 R96STM 1 20 R345SLM 2 R95STM 3 R891WM 2 R895SLM 4 R754SLM 1 R95STM 1 R951WM 1 R96STM 2 21 R354WM 11 R774WM 1 R957WM 1 R84STM 1 R96STM 1 R757SL 1 the first collum is the pallet number (1 onwards), 2nd is the model number and 3rd is the quanity of that model on that pallet. Now I need to total these up into another sheet. for example model total r774m 28 r295sl 57 This has to be in a table form as I do alot of calulations to do with sale price etc. Any help will be appreciated. thanks -- TAZGALSINH ------------------------------------------------------------------------ TAZGALSINH's Profile: http://www.excelforum.com/member.php...o&userid=31054 View this thread: http://www.excelforum.com/showthread...hreadid=507274 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with a table
T,
Is the data shown all in one column or three columns? The model numbers in the summary at the bottom of your post do not appear in the model numbers above? Jim Cone San Francisco, USA "TAZGALSINH" wrote in message HI all, I have a spreadsheet dealing with pallets that come into the company I work for. On each pallet there may only be one model or many different models with varying quantitys. 16 R874SLM 6 R874WM 5 R872SLM 1 R754SLM 3 R765SLM 1 17 R953SLM 8 R95STM 1 R774WM 1 R754SLM 1 R884SLM 1 R872SLM 1 R343GM 1 R96STM 2 18 R957SLM 12 R95STM 1 R383SLM 1 R345SLM 1 R771GM 1 19 R84STM 13 R85STM 4 R754SLM 2 R96STM 1 20 R345SLM 2 R95STM 3 R891WM 2 R895SLM 4 R754SLM 1 R95STM 1 R951WM 1 R96STM 2 21 R354WM 11 R774WM 1 R957WM 1 R84STM 1 R96STM 1 R757SL 1 the first collum is the pallet number (1 onwards), 2nd is the model number and 3rd is the quanity of that model on that pallet. Now I need to total these up into another sheet. for example model total r774m 28 r295sl 57 This has to be in a table form as I do alot of calulations to do with sale price etc. Any help will be appreciated. thanks -- TAZGALSINH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Change Data In Pivot Table | New Users to Excel | |||
Lookup Table Dilemma | Excel Worksheet Functions |