Date: 09/29/05 (Microsoft Windows)    Keywords: no keywords

Hi, I have a question about Excel.

Is it possible to get the values in one column to arrange their order to match that of another column? This is made harder by the fact that some values are blank on column 2 and not all values in 1 are present in 2.

Simple example:

Column 1
d
f
a
g
c
b
e

Column 2
e


b

f
a



g

c

Now I want to use a function to get column 2 to arrange its values in the same order as column 1.

In reality I am trying to manipulate a dataset with 40,000 entries!

Cheers.

Source: http://www.livejournal.com/community/ms_windows/45975.html