Validating subsequent duplicate rows based upon the first occurenc
 

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. Item ABC appears on Row 7 and the description
is in column K, the rest of the columns L:DQ are item attributes associated
to 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-