Thanks Paul
I struggled with that formula all last night and this morning.
I still need a lot of practice with excel Formulas

One further question about the sheet when I import new data I get the following issue as per the attachment does the sheet require another module to be added in VBA for this section

Kind regards
David