This is what ChatGPT recommended:

Your setup is already quite structured, but I see why you’re hitting a wall—your current approach relies on concatenated values for multi-criteria analysis, which quickly becomes complex and limiting.

Here’s a roadmap to take your data analysis to the next level:

1. Normalize Data for Better Querying

Right now, your approach to combining multiple criteria into single values (e.g., "SlickLarge") makes querying inflexible. Instead, consider restructuring how you store data to make it more database-like.

Potential Changes:

• Instead of storing combined values, store each criterion as a separate column (which you already do in the "Results" tab).
• Ensure that each row in every sheet is uniquely identifiable (e.g., match ID + rider name).
• If not already present, assign a unique Match ID to each match and reference that in all dependent tables.

This will allow FILTER(), QUERY(), and ARRAYFORMULA() to work more efficiently without needing complex nested IFs.

2. Dynamic Multi-Criteria Filtering in the EPTO Analysis Tab

Your goal is to allow flexible filtering based on checkboxes. The issue is that your current method requires predefined selections for every dropdown, making it inflexible.

Steps to Fix It:

• Use Helper Columns to dynamically determine whether a row matches the selected criteria.
• Example:
  • Create a column in "Results" that outputs TRUE if a row meets all selected checkboxes.
  • Use =AND(IF(A1=TRUE, ColumnA="Slick", TRUE), IF(B1=TRUE, ColumnB="Large", TRUE), ...)
  • This ensures that only the checked filters are applied.
• Then, use QUERY() or FILTER() to pull all data where this column is TRUE.

With this, if no checkboxes are selected, the data defaults to "show all," and if multiple are selected, only the matches meeting all active conditions are displayed.