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 is 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.
--
stwilson