I have a worksheet with a database sheet in which columns A represents a reference of an item .
All data in database sheet have unique reference but there are some who have different reference coding from column G to X .
My goal is to extract ONLY those who have different coding headers from G to X .
Those with one reference should not extracted e.g row 7 and 20 as as there is only one reference in column G and H in database sheet
Looking a formula to extract these on a sheet named data extract.
Note the database of 10000 records .
I think using small with index match may be approriate
Bookmarks