On Jan 29, 6:37*pm, gcotterl wrote:
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.- Hide quoted text -

- Show quoted text -

By the way, I'm using Microsoft Office Excel 2007.