I want to identify duplicate values in column K. I then want to compare cell
differences on each column/row between the first occurence of a value to
subsequent occurences of the same value. I want to have a list showing what
the value was in row K, the row numbers they occur on, and what the
differences were on the subsequent rows. If there are no differences then I
don't want to know.

One note the range of cells on each row is constant.

Can you elucidate a little on this:

compare cell differences on each column/row between
the first occurence of a value to subsequent occurences
of the same value.



"jonnybrovo815" wrote:

I want to identify duplicate values in column K. I then want to compare cell
differences on each column/row between the first occurence of a value to
subsequent occurences of the same value. I want to have a list showing what
the value was in row K, the row numbers they occur on, and what the
differences were on the subsequent rows. If there are no differences then I
don't want to know.

One note the range of cells on each row is constant.

In the excel spreadsheet we have many items in a Bill of material structure.
These items can repeat throughout the spreadsheet depending where the item is
needed. We use this to load information to a database (oracle). The way the
upload works is that the first occurence of an item and all of its values on
the row lets say K7:DQ7 are loaded to the database. Every other occurence of
the item description should have identical values for all of it's
columns-for consistency sake, but these values do not overwrite the values
from the first occurence. So say item K appears on Row 7 and the description
is in column K, the rest of the columns are item attributes for the item
description. If the item description also appears on row 23 of column K then
all values in columns L:DQ in the second occurence of the item description
needs to be the same. If not then I would like to know what and where the
difference is on the second occurrence so I can inquire to why the values are
different-

"JLGWhiz" wrote:

Can you elucidate a little on this:

compare cell differences on each column/row between
the first occurence of a value to subsequent occurences
of the same value.



"jonnybrovo815" wrote:

I want to identify duplicate values in column K. I then want to compare cell
differences on each column/row between the first occurence of a value to
subsequent occurences of the same value. I want to have a list showing what
the value was in row K, the row numbers they occur on, and what the
differences were on the subsequent rows. If there are no differences then I
don't want to know.

One note the range of cells on each row is constant.