Baseball Q - Return Multiple Matches in Column/VLookup?

Originally Posted by davesexcel

Hi there,

If you are using excel you could use the auto filter

heres a great read on AutoFilter

http://www.contextures.com/xlautofilter01.html

Thanks for the tip but I don't think autofilter will help me here because I am not looking to filter for specific years, rather I am looking to filter out various years based on the player's situation.

It would be quite simple to tell Excel to filter for data from 2006 or filter out data for years prior to 1975. But to ask Excel to filter out career data for players who did not play in 2006 while preserving career data for those who DID play in 2006, that's a little more complex.

It might sound more confusing than it actually is; I imagine there to be a simple solution but I have only taught myself Excel and have had no training.

A way to think of this in terms of customer payments since baseball might be confusing...

Customers under Column A
Year for which payments were made under Column B
Months for which payments were made under Columns C-N (12 months)
Total payments for the year under Column O

Over the 10 year history of the business, we have had hundreds of customers come and go and want to analyze payment data for just our current or most recent customers. We believe that we can do this by filtering only only for those customers who made payments during 2006. Keep in mind however that we want to show all of their payment data (and show all columns A:O at that) as long as they have been a customer, not just 2006 figures.

Originally Posted by davesexcel

Thanks, I am working on it, almost have it

Appreciate the help. I have a nutrition spreadsheet I'd like to post up on here as thanks but do not know what forum I would throw that under.

Eureka!

Had to use Access to accomplish this. Remember how I said I was able to isolate a list of the players who had served in 2006? (just not all their data!! ) I saved that list as its own .xls file and imported into the existing Access database. I created a relationship between the master list and that list and then queried the list with just 2006 players. Didn't have to enter any criteria in the query.

As for using just Excel to accomplish this, it is still a mystery.

Nice job on this. It takes out a step from what I did in allowing someone to analyze a specific player or customer if you will. My original desire was to just get rid of all of the retired players (or past customers) out of the database and then begin an analysis from there though this is quite helpful in its own right.

Thanks again for all your help.