-"The scores have to stay in the right column too"-
a point not mentioned in your first post.

List 1 has Batting Score and Football Score in columns B & C

List 2 has Hockey score and Skating score in columns E and F ? with
names in column D ?
and there are twice as many Hockey & Skating scores as there are
Batting & Football ?

and you want a complete list of names in column A with Cricket in B,
Football in C, D = optional, Hockey in E, and Skating in F

is this correct?

--

Blah Wrote:
do you mean twice as many rows or twice as many columns? if twice as
many rows then you have triplicates?
To see 4 headers above 3 columns can be a little confusing

note, it is also confusing if you use what are standard column headers
A B C & D as column A entries (without a heading entry), however, the
formula will still produce what you need, just delete the blank column
D when you are done.


I mean twice as many rows ie

List 1
Batting Score Football Score
Ben 3 4


List 2
Hockey Score Skating Score
Ace 1 2
Ben 3 7

All the entries in List 1 have 4 values. Half in List one and half in
List 2. List 2 has all the entries of List 1 and more entries that are
not in List 1. I can't arrange them seperately with the sort function
because since List 2 has twice as many entries the names still won't
align with each other. I need to get the scores next to their
respective name in one list. The scores have to stay in the right
column too.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535746