software

I was looking for a way to compare two groups of data on the same worksheet
then arrange the two groups of data based on the contents on one column in
each group. These two groups will have at least one row in common that I want
to line up side by side along with their counter part cells.
If a cell in one group matches a cell in the other group i want to line up
all of the other cells in that row of group A with those in group B. If there
is no match then shift all of the cells of the group B data down one row, and
push all of the other rows below the unmatched row down one also. Both of
these groups will have already been sorted on the common data column.
My Goal is to line up all of the data side by side from both groups so i can
see what other cells in that row have different data in them. These groups of
data will have 2 to 3 thousand rows.

Any ideas will be appreciated....ThanksThis task sounds like it would be done much more easily in Microsoft Access
than in Excel. However, if you must do it in Excel it probably could be done
with the VLOOKUP function and a whole bunch of copying and pasting. (Are
their duplicates of the common field? IE if ID# is the common field, can
there only be one ID# AA2 in group a and only one ID# AA2 in group b?)

Hope this helps.

Bill Horton

quot;nhoh0itquot; wrote:

gt; I was looking for a way to compare two groups of data on the same worksheet
gt; then arrange the two groups of data based on the contents on one column in
gt; each group. These two groups will have at least one row in common that I want
gt; to line up side by side along with their counter part cells.
gt; If a cell in one group matches a cell in the other group i want to line up
gt; all of the other cells in that row of group A with those in group B. If there
gt; is no match then shift all of the cells of the group B data down one row, and
gt; push all of the other rows below the unmatched row down one also. Both of
gt; these groups will have already been sorted on the common data column.
gt; My Goal is to line up all of the data side by side from both groups so i can
gt; see what other cells in that row have different data in them. These groups of
gt; data will have 2 to 3 thousand rows.
gt;
gt; Any ideas will be appreciated....Thanks
gt;