#1   Report Post  
 
Posts: n/a
Default 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).

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identify the contents of column in a filtered range Jeff Excel Worksheet Functions 6 June 26th 05 11:25 PM
Using contents of a cell in a formula Mike Excel Discussion (Misc queries) 4 June 9th 05 03:10 AM
How to insert the contents of two cells in a footer? Pank Excel Discussion (Misc queries) 4 June 2nd 05 02:32 PM
Can I use the contents of a cell to satisfy the result_vector arg. robh_2 Excel Worksheet Functions 3 February 24th 05 08:14 PM
Command: If the contents (text not numerical) of A1 in Sheet2 are. tommy Excel Worksheet Functions 1 February 2nd 05 11:40 PM


All times are GMT +1. The time now is 04:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"