I have a table with amongst other fields a date, person and location. I need a formula that will mark rows showing where date and location are the same, but the person is different, as the example below. There could be more than 2 persons at the same location each day. The person may have multiple records showing them at the same location each day. The current table is around 600 rows like this. Would appreciate any ideas, as I'm struggling to come up with anything myself.
Date Location Person Match
01/09/2019 London John Smith
01/09/2019 Southampton Jane Taylor
01/09/2019 Leicester Richard Rogers
01/09/2019 Exeter Richard Rogers x
01/09/2019 Exeter John Smith x
02/09/2019 Chelmsford Louise Wright
02/09/2019 Leicester Jane Taylor x
02/09/2019 Leicester Richard Rogers x
02/09/2019 Exeter John Smith
02/09/2019 Exeter John Smith
02/09/2019 Exeter John Smith
03/09/2019 Southampton Richard Rogers x
03/09/2019 Southampton Jane Taylor x
03/09/2019 Leicester Louise Wright
03/09/2019 London Louise Wright x
03/09/2019 London John Smith x
03/09/2019 London Louise Wright x
Date Location Person Match
01/09/2019 London John Smith
01/09/2019 Southampton Jane Taylor
01/09/2019 Leicester Richard Rogers
01/09/2019 Exeter Richard Rogers x
01/09/2019 Exeter John Smith x
02/09/2019 Chelmsford Louise Wright
02/09/2019 Leicester Jane Taylor x
02/09/2019 Leicester Richard Rogers x
02/09/2019 Exeter John Smith
02/09/2019 Exeter John Smith
02/09/2019 Exeter John Smith
03/09/2019 Southampton Richard Rogers x
03/09/2019 Southampton Jane Taylor x
03/09/2019 Leicester Louise Wright
03/09/2019 London Louise Wright x
03/09/2019 London John Smith x
03/09/2019 London Louise Wright x