LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Sorting Complicated List by Two Columns - Excel 2003

I have a list of names, represented below, but in reality about 1,000 names
long.

Column A has each name ONCE.

Column B has each name multiple times, but in no particular order.

I want to have the names in Column B be at the same place as column A. In
other words, for the name "John" in Column A, I want each instance of "John"
in Column B to come under that . What this will require is Excel to
AUTOMATICALLY insert additional cells (so that if John appears 20 times in
Column B, there are 19 blank lines under "John" in Column A).

PLEASE HELP!!!

Jeff John
John John
Saul John
Ralph Jeff
Jeff
Jeff
John
John
Saul
Saul
Jeff
Ralph
Jeff
Ralph
Ralph
Ralph
Ralph
John

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complicated Excel Mailing List [email protected] Excel Worksheet Functions 1 March 6th 07 01:37 AM
sorting in excel 2003 juju Excel Worksheet Functions 1 October 12th 06 11:39 PM
Sorting alphabetical list into multiple columns jp1733 Excel Worksheet Functions 3 August 16th 06 01:17 AM
Sorting in Excel 2003 Stars New Users to Excel 2 July 13th 06 10:33 PM
Sorting multiple columns as 1 list alphabetically? philpott Excel Discussion (Misc queries) 4 October 19th 05 06:31 PM


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"