Thread
:
Matching cells
View Single Post
#
7
Dave Peterson
Posts: n/a
How about just using a formula that looks for matches?
insert a new column B (moving the old column B to column C).
Then in B1, put this formula:
=if(isnumber(match(a1,c:c,0)),a1,"")
And drag down 60000 rows.
wrote:
I apparently deleted my June 17th posting so here it is:
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 down next to the cells in
Col A that have the matching 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
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?
============
Note: Neik's reply to that posting worked perfectly).
--
Dave Peterson
Reply With Quote