I currently have a list of values that are randomly populating a table with numbered rows and column headings. I would then like to be able to search this randomly populated table and pull a list of all the column/row identifiers separated by commas where the value can be found for each value within the original list. I would also like to be able to have the option of making the original list longer by leaving blank cells at the bottom that can be filled in to be randomly populated and then have their column/row identifiers pulled, however if the cells are blank in the original list then to just ignore them.
Attached are a screenshot of the spreadsheet and the original spreadsheet. Thank you!
Bookmarks