| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting same model number
Help!
Trying to sort multiple model numbers that are the same by combining the quantity. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting same model number
I'm sure you know exactly what you mean, but it's not clear to me what
"multiple model numbers that are the same" means, nor what "combining the quantity" means... Could you post an example in a reply? In article , excel question <excel wrote: Help! Trying to sort multiple model numbers that are the same by combining the quantity. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting same model number
Try SUMIF?
It's not really clear from your post what you're trying to do with your data. Dave -- Brevity is the soul of wit. "excel question" wrote: Help! Trying to sort multiple model numbers that are the same by combining the quantity. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting same model number
Hello, Dave!
You wrote on Thu, 16 Nov 2006 07:55:01 -0800: DF It's not really clear from your post what you're trying to DF do with your data. DF Dave DF -- DF Brevity is the soul of wit. DF "excel question" wrote: ?? Help! ?? Trying to sort multiple model numbers that are the same by ?? combining the quantity. Thanks. Would it not be best to consolidate the records with the same number before sorting? Otherwise, it seems to me to be something that Pivot Tables can handle. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting same model number
James--perhaps.
As I say, it's not really clear what the OP is looking to do, so it's hard to give a defintiive answer as to what the best solution is??? Dave -- Brevity is the soul of wit. "James Silverton" wrote: Hello, Dave! You wrote on Thu, 16 Nov 2006 07:55:01 -0800: DF It's not really clear from your post what you're trying to DF do with your data. DF Dave DF -- DF Brevity is the soul of wit. DF "excel question" wrote: ?? Help! ?? Trying to sort multiple model numbers that are the same by ?? combining the quantity. Thanks. Would it not be best to consolidate the records with the same number before sorting? Otherwise, it seems to me to be something that Pivot Tables can handle. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting numbers with an irregular number of digits | Excel Discussion (Misc queries) | |||
| Changing a Number in a Column Using Arrays | Excel Worksheet Functions | |||
| Sorting a six digit number by terminal digit | Excel Worksheet Functions | |||
| Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
| Matching parts to model numbers | Excel Discussion (Misc queries) | |||
Linear Mode
