« Return to Thread: Advanced Column Sorting in Excel 2003

Advanced Column Sorting in Excel 2003

by Bradj2 :: Rate this Message:

Reply to Author | View in Thread

Hi,

I am having difficulty sorting columns. How is it possible to sort data across multiple columns in Excel 2003.

For example, I have 7 columns from A to G that contain company names and each column contains part of the name as below.

Column A
TelePros

Columns A & B & C
Addilex Press Group

Columns A,B,C,D
Advanced Financial Group Inc

Columns A + B
BKJM LLC

Columns A, B,C,D,E,F,G
Boardwalk Hospital Partners Gulf South District Inc

etc, etc

In this example above, I would like to sort by those cells containing single names first (Col A) and then those containing 2 names (col A, B) and then 3 names in columns A, B & C etc, etc.

Please can you help.

Thank You,
Brad

 « Return to Thread: Advanced Column Sorting in Excel 2003

LightInTheBox - Buy quality products at wholesale price!