selecting data from cells

[ArturoCohen]

Hi, im having a little hard time here, id like to know if this can be
done. i have data sorted like this:

Col1 col2 col3
R1 a2 b5 r9
r2 t6 a2 q7
r3 r9 t6 b5

so, many data can repeat but in different columns and rows. i need to
make a list in another column of all of that data, but they should only
be copied once. so it looks like this:

a2
b5
r9
t6
q7

is this possible in excel 2000?

thanks for the help you could provide.

Arthur

 

[oldchippy]

Hi, im having a little hard time here, id like to know if this can be
done. i have data sorted like this:

Col1 col2 col3
R1 a2 b5 r9
r2 t6 a2 q7
r3 r9 t6 b5

so, many data can repeat but in different columns and rows. i need to
make a list in another column of all of that data, but they shoul
only
be copied once. so it looks like this:

a2
b5
r9
t6
q7

is this possible in excel 2000?

thanks for the help you could provide.

Arthur

Hi rturoCohen,

Copy col B and col C and put in col A, then do a Data > Filter
Advanced filter, copy to other location, unique records only.

oldchippy :

 

[ArturoCohen]

yes, that would be the hard work way, i just thought there may be a
way of doing this simple with some macro or formulae.

but thanks.