ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Find Dups in a column, validate all dup rows are identical. (https://www.excelbanter.com/excel-programming/390758-find-dups-column-validate-all-dup-rows-identical.html)

jonnybrovo815

Find Dups in a column, validate all dup rows are identical.
 
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-



All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com