Hi Folks,
I'm copying a variable range of data which may or may not contain a repeating list of values in column A. In the case there IS a repeating list, I would like to keep only the first 'set' and delete all rows below. Turning this...
Prod1
Prod2
Prod3
Prod4
Prod5
Prod1
Prod2
Prod3...