I have a sheet showing the 46 results progressively over a season for
my team (23 Home and 23 away fixtures)
These are displayed in rows with columns showing opposition name, Home
score, Away score and Venue (H(ome) or A(way))
The Venues column will have random order E.G. H,A,H,H,A,H,A etc

I would like to pick out from these 46 results the Home results and
Away results and place them in separate lists automatically.

Is there a formula to do this please.

Thanks
Neil