I probably do not totally understand your requirements but it would appear you could accomplish everything you want in Excel. However, if you really don't want

I probably do not totally understand your requirements but it would appear you could accomplish everything you want in Excel. However, if you really don't want to use Excel, and you have some programming chops, you could export the Excel spreadsheet into a database (say MySQL). Once the information is in a database, the queries you can run are only limited by your imagination.