Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cells together when sorting
Hi there,
I have a user who is trying to sort a spreadsheet. He has 2 columns. 1 = Company name 2 = value eg: Microsoft Games 25479 Microsoft Windows 45524 Bizarre Creations 98445 eBay 17889 Skype 65788 The user would like to sort by value, but somehow keep the companies together. Skype and eBay are owned by the same company, but if you search by value it will put ebay near the top and skype near the bottom. Same with MS. Bizarre is owned by MS, but if you sorted by value it would be near the top and other MS companies would be near the top. Basically, he wants multiple cells to act as one cell. Is this possible? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cells together when sorting
Hi,
Not clear what you want, I think you want to keep companies together and then sort by value within the company, in that case select both columns and 1st criteria for sorting will be by company, then select a 2nd criteria and here you select by value if this helps please click yes, thanks "IT Drew" wrote: Hi there, I have a user who is trying to sort a spreadsheet. He has 2 columns. 1 = Company name 2 = value eg: Microsoft Games 25479 Microsoft Windows 45524 Bizarre Creations 98445 eBay 17889 Skype 65788 The user would like to sort by value, but somehow keep the companies together. Skype and eBay are owned by the same company, but if you search by value it will put ebay near the top and skype near the bottom. Same with MS. Bizarre is owned by MS, but if you sorted by value it would be near the top and other MS companies would be near the top. Basically, he wants multiple cells to act as one cell. Is this possible? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking then sorting | New Users to Excel | |||
checkboxes:linking with cells and sorting | Excel Discussion (Misc queries) | |||
Linking cells for sorting purposes | Excel Discussion (Misc queries) | |||
Linking messed up when Sorting | Excel Discussion (Misc queries) | |||
Linking between worksheets- then sorting data | Excel Worksheet Functions |