Remove Rows where 3 out of 5 column values are identical
Sep 9, 2014 12:52 PM(1978 views)
I having been trying to find a way to remove rows that have identical cells in some columns but not in others.
For example I want to find rows where values for columns PartNo, SerialNum and Site are identical but not Customer and Value. Then I want to delete one of these rows. In this case I would be left with row 1,3 and 4-see below.
If you want to do it through scripting, the following code shows an example which retains only the first instance of a duplicate row. It exploits the fact that the summary table is linked to the detail table.