What I am trying to accomplish is to create a new table for each two letter abbreviation found in the Variables tab. Within each newly created table, I would like to see every cell from the two randomly generated tables on the Grids tab that contains that specific two letter abbreviation. For example, CH. Here's the tricky part. I want each cell that contains the two letter abbreviation to be represented by a combination of the headers (column headers found in row 1 + row 8 AND the row headers found in column A). Sample results: 011, 021, 121, 311, 554.
Find all cells that contain CH and list the column header and row header in a cell together for each occurrence of CH in the two tables on the Grids tab. I am attaching a sample file with additional descriptors that I hope will explain more.
- two randomly generated tables on the Grids tab have a column header and row header (see Grids)
- randomly generated data consists of two letter abbreviations (see Variables & Grids)
- I need to pull from random table data every cell that contains a specific two letter abbreviation. For example, every cell that contains CH
- and show the column header and row header (combined in one cell) for each cell that contains the two letter abbreviation
My question is: Is there a way to systematically find every cell that contains specific text and display the column header/row header for each occurrence found within a range of cells? Please see my attached sample for further clarity.
The two tables on the Grids tab are randomly generated. They most likely re-randomized...making my example harder to understand.