Help with filter formula or similar please?

[Kaarthuul]

Hi all,

I have used the filter function to pull out Scotland.

I need a formula to filter everything else [England, England and Scotland, Unknown & Invalid], all added together by date [signified by the first 8 characters].

e.g. 20240626 28668 28226 2512 64 29

Hope this makes sense?

Regards,

Clive

[JeteMc]

"...or similar"
1. Column headers could be added to the data and then the data could be filtered using the filter button in cell C1
2. A pivot table could be produced and the data could be filtered using either a filter button in cell C3 or a slicer
Let us know if you have any questions.