Forum Discussion
highlight duplicates in sheets with 2 criteria
I Have a workbook with multiple sheets and I want to highlight the row if the value in column A "Shipment NO" & column E "SKU" both have been duplicated in other sheets below is what I'm looking for...
SKU are in column E?
Yes ,the column A "Shipment NO" & column E "SKU"
if with sql,
create temp table aa00 as
select colIndex[1:7] from consolidateSheet where regexp('\d+',f04) or rowid=1;
cli_no_header;
cli_mark_duplicate_rows~aa00~f03,f07;
select * from aaGrp;