My guess is that there is a possibility to write a formula that would be in
column D, and maybe also in column E, that would copy and paste the data
into columns D and E when there is a name both columns B and C. This would
make the copy and paste automatic instead of manually copying and pasting.
Johnny, you are correct that sorting does "compact" columns D and E. The
problem still remains how to get the data out of columns A and B into
columns D and E. If it is not possible to get the data out of columns A and
B, then it is a help knowing that columns D and E can be "compacted by doing
a
Well, the simple answer would probably be to sort columns D and E.
Johnny Rosenberg
2009/10/26 Walter Hildebrandt :
> My question is, how can I do the following?
>
> There are 200 rows involved. The following explains the question.
>
> Cell A1 has the number 1 in it, cell A2 has 2 in it, cell A
My question is, how can I do the following?
There are 200 rows involved. The following explains the question.
Cell A1 has the number 1 in it, cell A2 has 2 in it, cell A3 has 3, cell A4
has 4
Cells B1 has the name name1 in it, cell B2 has name2 in it, cell B3 has
name3, cell B4 has name4
Cell