Single Cell Text List with Dynamic Response

Originally published at: Create a Single Cell Text List with Dynamic Response - Excelbuddy.com

Dealing with a single cell text list can be challenging in Excel. You cannot use VLOOKUP or XLOOKUP as search functions to returns results. Additionally, depending on the incoming data, re-configuring the data can take longer than its worth. Let me explain the scenario in Excel. You have a kids sporting event and you have…