Help with a formula to determine repeat customers, and if they upgrade

Hi,

So I'd love a little help.

I'm trying to work out my percentage of repeat versus new customers based on whether or not they've attended an event of ours in the past - but also if they've chosen to run the same distance, or another, as in they can choose between a 5km& 10km race distance, and on some othe events we have a 15km race.

The sheet goes a little like this...

Event Name Event ID Order no. Order Date Prefix First Name Surname Suffix Email Guest Of Guestlist Quantity Ticket Type
Rough Runner Clapham Common Saturday 16442169973 413899569 2015-04-11 John Smith [email protected] 1 Launch Special (Group rate) 5KM
Rough Runner Clapham Common Saturday 16442169973 414628557 2015-04-14 Emma Edwards [email protected] 1 Launch Special (Group rate) 5KM
Rough Runner Clapham Common Saturday 16442169973 416185783 2015-04-18 Chloe Bost [email protected] 1 Launch Special (Group rate) 5KM
Rough Runner Clapham Common 2016 Saturday 19379527689 470693682 2015-11-09 Darren Wilson [email protected] 1 Launch Special (Individual) 5KM
Rough Runner Clapham Common 2016 Saturday 19379527689 470699591 2015-11-09 Katie Woods [email protected] 1 Launch Special (Group rate) 10KM
Rough Runner Clapham Common 2016 Sunday 19443590302 470942041 2015-11-09 Dionne Wyatt [email protected] 1 Launch Special (Group rate) 10KM
Rough Runner Clapham Common 2016 Sunday 19443590302 471266465 2015-11-10 Amy Cook [email protected] 1 Launch Special (Individual) 5KM
Rough Runner Clapham Common 2016 Sunday 19443590302 471551765 2015-11-11 Tracey Leslie example{@email6.com 1 Launch Special (Group rate) 10KM
Rough Runner Clapham Common 2017 - Saturday 29610777633 574376419 2016-11-24 Emma Bassett [email protected] 1 Launch Special (Group rate) 5KM
Rough Runner Clapham Common 2017 - Saturday 29610777633 574389768 2016-11-24 Lucie Rooke [email protected] 1 Launch Special (Group rate) 5KM
Rough Runner Clapham Common 2017 - Saturday 29610777633 574401472 2016-11-24 Lyndsey Bullock [email protected] 1 Launch Special (Group rate) 10KM

https://www.excelforum.com/attachmen...1&d=1507285108

Any ideas!

I'm pulling my hair out trying to work this one out!

It's probably best to compare based on their email addresses?