gcotterl expressed precisely :
On Jan 29, 4:48*pm, GS wrote:
gcotterl has brought this to us :

Yes, I want to have cells A that have a match in cells O to be lined
up in the same row. *(I tried describing this concept several ways
but *couldn't come up with the right words).

I ran ConditionalFormatting on $O:$O to place a border around each
dupe, and shading. There's lots!

The data appears to have unique values (ie: no dupes as far as I can
see) in each section. This means you won't have multiples of the same
value in the same section.

Both sections are sorted ascending. This would put the order of the 2nd
section as not sorted. Is this what you want? If so, I suggest to
locate (row position) 2nd section value in $A:$A, cut the cells in 2nd
section, insert (shift down) cut cells in 2nd section at found row
position.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

I can re-sort the 2nd section so the matches in both sections will be
lined up in the same row.

Sorting the 2nd section just sorts its data. Since the first section
has more rows, the matches will not end up on the same row. The sort
result would be what you have now.

Also, lining up 2nd section dupes with 1st section rows means there
will be blanks in 2nd section.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc