Spreadsheet: 542312d1507805647-highlighting-row-with-duplicate-text-sample
Sheet: Main Venue - Mock Up Results

 |  | Friday | Saturday | Friday | Saturday | Friday (BH) | Saturday |  | Friday | Saturday | Friday | Saturday | Friday | Saturday | Friday | Saturday |  | Friday | Saturday | Friday | Saturday | Friday | Saturday | Friday | Saturday |  | Friday | Saturday | Friday | Saturday | Friday | Saturday | Friday | Saturday | Friday | Saturday |  | Friday | Saturday | Friday | Saturday | Friday | Saturday | Friday | Saturday |  | Friday | Saturday | Friday | Saturday | Friday | Saturday | Friday | Saturday | Friday |  | Saturday | Friday | Saturday | Friday | Saturday | Friday | Saturday | Friday | Saturday |  | Friday | Saturday | Friday | Saturday | Friday | Saturday | Friday | Saturday |  | Friday | Saturday | Friday | Saturday
 |  | 2018-03-16 00:00:00 | 2018-03-17 00:00:00
Venue 1 |  |  |  |  |  | V! |  | April | Dynamite |  | Variety |  |  |  |  |  | May |  |  |  | Variety |  |  |  | Scotland | June |  |  | Variety |  |  |  |  |  | Posh | Remix | July |  | Chix | Scotland | Variety |  | Dynamite |  | V! | August |  |  | Variety |  | Moondogs |  |  |  |  | September |  |  | Variety |  | Posh | Scotland |  |  |  | October | V! |  | Variety | Dynamite |  |  |  |  | November |  |  |  |  | No Repeats (False)
Venue 2 |  |  |  |  |  |  | V! |  |  | Dynamite |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  | Scotland |  |  |  |  |  | Variety |  |  |  |  | Remix | Posh |  | Chix |  | Variety | Scotland | Dynamite |  | V! |  |  |  |  |  | Variety |  | Moondogs |  |  |  |  |  | Variety |  | Posh |  |  | Scotland |  |  |  |  | V! | Dynamite | Variety |  |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 3 |  |  |  |  |  |  |  |  | CJ/ |  | Dynamite |  |  |  | V! |  |  |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  |  | Posh | Chix |  |  |  |  | Variety | V! |  | Remix | Fresh |  |  |  |  | Variety |  | Dynamite |  |  |  |  |  | Moondogs |  |  | Lady Z | Variety |  |  |  | Chix |  |  |  | Variety |  |  |  |  |  |  | Dynamite |  |  |  |  |  | No Repeats (False)
Venue 4 |  |  |  |  |  |  |  |  |  | CJ/ |  | Dynamite |  |  |  | V! |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  | Posh |  |  | Chix |  |  |  | V! | Variety | Remix |  |  | Fresh |  |  |  |  | Variety |  | Dynamite |  |  |  |  |  |  | Moondogs | Variety | Lady Z |  |  | Chix |  |  |  |  |  | Variety |  |  |  |  | Dynamite |  |  |  |  |  |  | No Repeats (False)
Venue 5 |  | Remix | Posh |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  | 90's J |  |  | Variety |  |  |  |  |  | Chix |  | Variety |  |  |  |  |  |  | Wilkes |  |  | Posh |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  |  |  | Variety |  |  |  | Chix |  |  |  |  | Variety |  | Remix |  |  |  |  |  | No Repeats (False)
Venue 5 |  | Posh | Remix |  |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  | 90's J | Variety |  |  |  |  |  |  |  | Chix |  | Variety |  |  |  |  |  | Fresh | Wilkes | Posh |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  | Chix |  |  | Variety |  | Remix |  |  |  |  |  |  | No Repeats (False)
Venue 7 |  |  |  | Posh |  |  |  |  |  |  | CJ/ |  |  |  |  |  |  | OTE |  |  | Variety |  |  |  |  |  |  |  | Variety |  | Chix |  |  |  |  |  |  |  |  | OTE | Variety | Posh | Remix |  |  |  |  |  | Variety |  |  |  |  |  | Chix |  |  |  |  |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  | OTE |  |  |  |  |  |  | No Repeats (False)
Venue 8 |  |  |  |  | Posh |  |  |  |  |  |  | CJ/ |  |  |  |  |  |  | OTE | Variety |  |  |  |  |  |  |  |  |  | Variety |  | Chix |  |  |  |  |  |  |  | Variety | OTE | Remix | Posh |  |  |  |  |  |  | Variety |  |  |  |  |  |  | Chix |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  | OTE |  |  |  |  |  | No Repeats (False)
Venue 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Posh |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 10 |  | Wilkes | OTE | Lady Z |  | Remix | Posh |  |  |  |  |  | Variety |  |  |  |  |  |  | Moondogs |  |  | Variety | OTE | Dynamite |  | Chix |  |  |  |  |  | V! | Variety |  |  |  |  |  |  |  | Variety |  | Posh | Remix |  |  |  |  | OTE | Dynamite | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  | Chix |  |  |  |  |  | Variety |  |  | Posh |  |  |  |  |  | No Repeats (False)
Venue 11 |  | OTE | Wilkes |  | Lady Z | Posh | Remix |  |  |  |  |  |  | Variety |  |  |  |  |  |  | Moondogs | Variety |  | Dynamite | OTE |  |  | Chix |  |  |  |  | Variety | V! |  |  |  |  |  |  |  |  | Variety | Remix | Posh |  |  |  | OTE |  | Variety | Dynamite |  |  |  |  |  |  |  |  |  |  | Variety | Chix |  |  |  |  |  |  |  | Variety | Posh |  |  |  |  |  |  | No Repeats (False)
Venue 12 |  |  |  | OTE |  |  |  |  | Remix | Posh | Variety |  |  |  |  |  |  |  |  |  | Variety | Chix |  | V! |  |  |  | OTE | Variety | Dynamite |  |  | Wilkes |  |  |  |  |  |  |  | Variety |  |  |  |  |  | Posh | Remix |  | Variety |  |  | OTE |  | Dynamite |  |  | Moondogs | Chix | Lady Z | Variety |  |  |  |  |  |  |  | Variety |  |  | Posh |  | V! |  |  |  |  |  | No Repeats (False)
Venue 13 |  |  |  |  | OTE |  |  |  | Posh | Remix |  | Variety |  |  |  |  |  |  |  | Variety |  |  | Chix |  | V! |  | OTE |  | Dynamite | Variety |  |  |  | Wilkes |  |  |  |  |  | Variety |  |  |  |  |  |  | Remix | Posh | Variety |  |  |  |  | OTE |  |  | Dynamite | Chix | Moondogs | Variety | Lady Z |  |  |  |  |  |  |  |  | Variety | Posh |  | V! |  |  |  |  |  |  | No Repeats (False)
Venue 14 |  |  |  |  |  |  |  |  |  |  | Remix | Posh | Variety |  | Wilkes |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  |  | Variety | [NAME] |  |  |  | Wilkes |  | Posh | Remix |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  | No Repeats (False)
Venue 15 |  |  |  |  |  |  |  |  |  |  | Posh | Remix |  | Variety |  | Wilkes |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | One Off | Variety |  |  |  |  | Wilkes | Remix | Posh | Variety |  |  |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 16 |  |  |  |  |  |  |  |  | Variety |  |  |  | Remix | Posh |  |  |  |  | Variety | Chix |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  | Posh | Remix |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  | Chix |  |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 17 |  |  |  |  |  |  |  |  |  | Variety |  |  | Posh | Remix |  |  |  | Variety |  |  | Chix |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  | Remix | Posh |  |  | Variety |  |  |  |  |  |  |  |  |  |  |  |  | Variety | Chix |  |  |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 18 |  |  |  |  |  |  |  |  |  |  | Variety |  |  |  | Remix | Posh |  |  |  |  | Variety |  |  | Chix |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  | Posh | Remix |  |  |  |  | Variety |  | Chix |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 19 |  |  |  |  |  |  |  |  |  |  |  | Variety |  |  | Posh | Remix |  |  |  | Variety |  |  |  |  | Chix |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  | Remix | Posh |  |  |  | Variety |  | Chix |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | No Repeats (False)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 20 |  | Chix |  |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  | Remix | Posh |  |  |  | Variety | 90's F |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  | Chix |  |  | Variety |  |  |  | Posh |  | Remix |  |  |  |  |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 21 |  |  | Chix |  |  |  |  |  |  |  |  |  |  | Variety |  |  |  | Posh | Remix |  |  | Variety |  |  | 90's F |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  | Chix |  |  |  |  | Variety |  |  | Remix |  | Posh |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  | No Repeats (False)
Venue 22 |  |  |  | Chix |  |  |  |  | Variety |  |  |  |  |  |  |  |  | Established | Variety | Remix | Posh |  |  |  | Wilkes |  | Variety |  |  |  |  |  |  |  |  | Chix |  |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety | Posh | Remix |  |  |  |  |  |  |  | Variety |  |  |  | Wilkes |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 23 |  |  |  |  | Chix |  |  |  |  | Variety |  |  |  |  |  |  |  | Variety | Established | Posh | Remix |  |  | Wilkes | 90's J |  |  | Variety |  |  |  |  |  |  | Chix |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  | Variety |  |  | Remix | Posh |  |  |  |  |  |  |  |  | Variety |  |  |  | Wilkes |  |  |  |  |  |  |  | No Repeats (False)
Venue 24 |  |  |  | Remix |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  | Variety |  |  |  |  | 90's J |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 25 |  |  |  |  |  | Chix |  |  |  |  |  | Variety |  |  |  |  |  | 90's J |  | Variety | Wilkes | Remix | Posh | Established |  |  |  |  |  | Variety |  |  | 90's J |  |  |  |  |  |  | Variety |  |  |  |  | Chix |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety | Remix |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 26 |  |  |  |  |  |  | Chix |  |  |  | Variety |  |  |  |  |  |  |  | 90's J | Wilkes | Variety | Posh | Remix |  | Established |  |  |  | Variety |  |  |  |  | 90's J |  |  |  |  |  |  | Variety |  |  | Chix |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  |  | Remix | Variety |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 27 |  |  |  |  |  | Wilkes | 90's J |  | Chix |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety | Remix | Posh |  |  | 90's J |  |  |  |  | Variety |  |  |  |  |  |  |  | Chix |  | Variety |  |  |  |  |  |  |  | Variety |  | 90's J |  |  |  |  |  |  |  | Variety | Posh | Remix |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 28 |  |  |  |  |  | 90's J | Wilkes |  |  | Chix |  |  |  | Variety |  |  |  |  |  |  |  | Variety |  | Posh | Remix |  | 90's J |  |  |  |  |  |  | Variety |  |  |  |  |  | Chix |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  | 90's J |  |  |  |  |  | Variety |  | Remix | Posh |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  | No Repeats (False)
Venue 29 |  |  |  |  |  |  |  |  |  | Variety | Chix |  |  |  | 90's J |  |  | Variety |  |  |  |  |  |  |  |  | Remix | Variety | Wilkes | Posh |  |  |  |  |  | 90's J |  |  | Variety |  |  |  | Chix |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety |  |  |  |  |  |  | Posh | Remix |  | Variety |  |  |  |  |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 30 |  |  |  |  |  |  |  |  | Variety |  |  | Chix |  |  |  | 90's J |  |  | Variety |  |  |  |  |  |  |  | Variety | Remix | Posh | Wilkes |  |  |  |  | 90's J |  |  | Variety | Tthreat |  |  | Chix |  |  |  |  |  | Variety |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  | Remix | Posh |  |  | Variety |  |  |  |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 31 |  |  |  |  |  |  |  |  |  |  |  |  | OTE | Variety |  |  |  | Chix |  |  |  | Variety |  |  |  |  | Posh |  | Remix | Lady Z |  |  | OTE | Variety | Established |  |  | Dynamite | Moondogs |  |  | Variety | Wilkes |  |  |  |  |  |  |  | Variety |  | Chix |  |  |  |  |  |  |  | Variety | Lady Z | OTE |  | Dynamite |  | Posh | Remix |  |  | Variety |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 32 |  |  |  |  |  |  |  |  |  |  |  |  | Variety | OTE |  |  |  |  | Chix |  |  |  | Variety |  |  |  |  | Posh | Lady Z | Remix |  |  | Variety | OTE |  | Established |  | Moondogs | Dynamite |  |  | Wilkes | Variety |  |  |  |  |  |  |  |  | Variety |  | Chix |  |  |  |  |  | Variety |  | OTE | Lady Z | Dynamite |  |  | Remix | Posh |  |  |  | Variety |  |  |  |  |  |  |  | No Repeats (False)
Venue 33 |  |  |  |  |  |  |  |  | OTE |  |  | Variety | Chix |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  |  |  | Variety | Remix | Lady Z |  |  |  |  |  | OTE |  | Established | Variety |  |  |  |  |  |  |  |  | Chix | V! |  |  |  |  |  |  |  | OTE |  |  |  |  | Lady Z | Wilkes |  |  |  |  | Remix | Chix |  |  |  |  |  |  |  |  | No Repeats (False)
Venue 34 |  |  |  |  |  |  |  |  |  | OTE | Variety |  |  | Chix |  |  |  |  |  |  | Variety |  |  |  |  |  |  |  | Variety |  | Lady Z | Remix | Posh |  |  |  |  |  | OTE | Variety | Established |  |  |  |  |  |  |  | Chix |  |  | V! |  |  |  |  |  | OTE |  |  |  |  |  | Wilkes | Lady Z |  |  |  | Remix | Posh |  | Chix |  |  |  |  |  |  |  | No Repeats (False)
Venue 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remix |  |  |  |  |  |  |  | No Repeats (False)
Venue 36 |  |  |  |  |  | OTE |  |  |  |  |  |  |  |  |  | Chix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Posh |  | OTE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V! |  |  |  | OTE |  |  |  | Posh |  | Remix |  |  | Chix |  |  |  |  |  | No Repeats (False)
 |  | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats |  | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats |  | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats |  | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats |  | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats |  | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats |  | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats |  | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats | No Repeats |  | No Repeats | No Repeats | No Repeats | No Repeats
Colour Code 1
Colour Code 2 |  | To show that in each column that there are no duplicates at all. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check in each row that there are no repeats more than 3 times. Either it shows in Column CC or the repeated text is highlighted.
Colour Code 3
Colour Code 4
Colour Code 5