Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default Matching cells

A1 thru A10 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.

A B
1 1 1
2 2 3
3 3 4
4 4 6
5 5 8
6 6 10
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
A that have the same contents. For example:

A B
1 1 1
2 2
3 3 3
4 4 4
5 5
6 6 6
7 7
8 8 8
9 9
10 10 10

In my actual spreadsheet, Col A contains 60,000 cells and Col B
contains 23,000 cells.

Besides dragging and dropping, is there a better way to do this?

 
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
How do I compare data in two worksheets to find matching cells? Gary Excel Discussion (Misc queries) 4 March 2nd 06 09:04 PM
how to count matching cells? gary dickinson Excel Discussion (Misc queries) 6 May 9th 05 02:24 AM
Matching cells gcotterl Excel Discussion (Misc queries) 1 February 1st 05 10:32 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM


All times are GMT +1. The time now is 03:02 AM.

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

About Us

"It's about Microsoft Excel"