Lets say I have a large baseball database with every players stats from every season for every year and every team on which he played and I want to extract to a worksheet (via a formula) all the stats for lets say one team from a given year but bring in all the stats each player had for the entire year even if that player played on other teams that same year. Not even sure if that was english but if you follow me can it be done?