I have an soccer database with about 50.000 results.
Database is built on date (old to new) and teams are standing under each other.
What i want and not getting right with a Pivot table and hope someone knows how with VB
Every week i want an overview wich teams had 2 or more draws in there last games (selection on the home team column F).
Now i have to select each team and see in column AB if it was a draw.
AB = results after 90 minutes
AC = results after 45 minutes
Is this possible with VB and hope with one push on a button....
Hope everything is clear and someone can help me. Questions please ask them.
Greetings,
Richard