Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My sheet contains in A1:B500 lots of pairs, some of which are repeated
............A.............B 1........light........team 2........table.........cup 3........cup.........water 4.........light........team 5.........water......wine I am interested in removing the duplicated rows (in the case above light -- team), pushing the rest of the pairs up. If possible, although it can complicate things, I want to sort the pairs by column A. Is it possible to do all this only with formulas? (I don't want to use advanced filter) It would help a lot. Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
create pairs of addresses? | Excel Discussion (Misc queries) | |||
how do I count pairs of cells when each matches a condition? | Excel Discussion (Misc queries) | |||
Labeling Data Pairs | Charts and Charting in Excel | |||
Numbering data pairs | Charts and Charting in Excel | |||
Merge file pairs | Excel Discussion (Misc queries) |