ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Matching contents (https://www.excelbanter.com/excel-discussion-misc-queries/32935-matching-contents.html)

[email protected]

Matching contents
 
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).



All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com