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!

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!