Well, the simple answer would probably be to sort columns D and E. Johnny Rosenberg
2009/10/26 Walter Hildebrandt <wh2...@gmail.com>: > 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 C1 is empty, C2 has hame2 in it, cell C3 is empty, C4 has name4 > > The 2 from cell A2 is copied into cell D1 and name2 from cell B2 is copied > into > E1 Also the number 4 in cell A4 is copied into cell D2 and name4 from cell > B4 is copied into E2. > > In other words when both Columns B and C have the same name in them then > columns A and B are copied to columns D and E and everything that is copied > is "compacted" so there are on empty rows between what is copied into > columns D and E > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org