software

Hi,

How / Is it possible to match entries in lists that are in a random
order and are different lengths

i.e.

col1 col2
1 1
2 2
5 7
6 6
8 9
3 3
4 4
7
9

To get
col 1 col 2
1 1
2 2
3 3
4 4
5
6 5
7 6
8
9 9

Being in order isnt particuarly important but matching up the values
is.

Thanks in advance.

Regards,
Steve--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile: www.excelforum.com/member.php...oamp;userid=33107
View this thread: www.excelforum.com/showthread...hreadid=530441Sort one of the lists (Datagt;Sort)
In the column adjacent to the sorted list use a VLOOKUP() formula

Let's say the sorted list is in A1:A100, and the other list you want to
match is in D1100. In B1 put this formula and copy it down

=if(isna(vlookup(a1,$d$1:$d$100,1,0)),quot;quot;,vlookup(a 1,$d$1:$d$100,1,0))

quot;steev_jdquot; wrote:

gt;
gt; Hi,
gt;
gt; How / Is it possible to match entries in lists that are in a random
gt; order and are different lengths
gt;
gt; i.e.
gt;
gt; col1 col2
gt; 1 1
gt; 2 2
gt; 5 7
gt; 6 6
gt; 8 9
gt; 3 3
gt; 4 4
gt; 7
gt; 9
gt;
gt; To get
gt; col 1 col 2
gt; 1 1
gt; 2 2
gt; 3 3
gt; 4 4
gt; 5
gt; 6 5
gt; 7 6
gt; 8
gt; 9 9
gt;
gt; Being in order isnt particuarly important but matching up the values
gt; is.
gt;
gt; Thanks in advance.
gt;
gt; Regards,
gt; Steve
gt;
gt;
gt; --
gt; steev_jd
gt; ------------------------------------------------------------------------
gt; steev_jd's Profile: www.excelforum.com/member.php...oamp;userid=33107
gt; View this thread: www.excelforum.com/showthread...hreadid=530441
gt;
gt;


Thanks.

I have a similar problem where i have two rows in each table. So i need
to go from this

a?1 a?1
b?2 c?2
c?2 d?6
d?7

to this
a?1 a?1
b?2
c?2 c?2
d?7 d?6

Any suggestions?--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile: www.excelforum.com/member.php...oamp;userid=33107
View this thread: www.excelforum.com/showthread...hreadid=530441You've got a reply at your later post.

steev_jd wrote:
gt;
gt; Thanks.
gt;
gt; I have a similar problem where i have two rows in each table. So i need
gt; to go from this
gt;
gt; a?1 a?1
gt; b?2 c?2
gt; c?2 d?6
gt; d?7
gt;
gt; to this
gt; a?1 a?1
gt; b?2
gt; c?2 c?2
gt; d?7 d?6
gt;
gt; Any suggestions?
gt;
gt; --
gt; steev_jd
gt; ------------------------------------------------------------------------
gt; steev_jd's Profile: www.excelforum.com/member.php...oamp;userid=33107
gt; View this thread: www.excelforum.com/showthread...hreadid=530441

--

Dave Peterson