pivotguy
02-15-2016, 06:20 PM
I would like to color coded those excel records
1. Where Rep Name and Customer values are identical between two or multiple rows.
2. And Same Rep sale SAMSPEDO and HYPOVALLEY products within 7 days to the same customer
I have 200 K records in excel file. Any suggestion.
see the test.xls ( few records only) file
1. Where Rep Name and Customer values are identical between two or multiple rows.
2. And Same Rep sale SAMSPEDO and HYPOVALLEY products within 7 days to the same customer
I have 200 K records in excel file. Any suggestion.
see the test.xls ( few records only) file