Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
E1 thru E10 contains sequentially-sorted data. B1 thru B6 contains
sequentially-sorted data which matches SOME (but not ALL) of the data in Col A. For example. B E 1 1 1 2 3 2 3 4 3 4 5 4 5 6 5 6 10 6 7 7 8 8 9 9 10 10 I need to move the data in the cells in Col B next to the cells in Col E that have the same contents. For example: B E 1 1 1 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 8 8 9 9 10 10 10 Besides dragging and dropping, is there a better way to do this? (In my actual spreadsheet, Col B contains 718 cells and Col E contains 65,530 cells). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identify the contents of column in a filtered range | Excel Worksheet Functions | |||
Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
How to insert the contents of two cells in a footer? | Excel Discussion (Misc queries) | |||
Can I use the contents of a cell to satisfy the result_vector arg. | Excel Worksheet Functions | |||
Command: If the contents (text not numerical) of A1 in Sheet2 are. | Excel Worksheet Functions |