Random table of data - need to find every cell that contains specific data

S

stwilson

What I am trying to accomplish is to create a new table for each tw
letter abbreviation found in the Variables tab. Within each newl
created table, I would like to see every cell from the two randoml
generated tables on the Grids tab that contains that specific two lette
abbreviation. For example, CH. Here's the tricky part. I want each cel
that contains the two letter abbreviation to be represented by
combination of the headers (column headers found in row 1 + row 8 AN
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 heade
in a cell together for each occurrence of CH in the two tables on th
Grids tab. I am attaching a sample file with additional descriptors tha
I hope will explain more.


- two randomly generated tables on the Grids tab have a column heade
and row header (see Grids)
- randomly generated data consists of two letter abbreviations (se
Variables & Grids)
- I need to pull from random table data every cell that contains
specific two letter abbreviation. For example, every cell tha
contains CH
- and show the column header and row header (combined in one cell) fo
each cell that contains the two letter abbreviation


My question is: Is there a way to systematically find every cell tha
contains specific text and display the column header/row header for eac
occurrence found within a range of cells? Please see my attached sampl
for further clarity.

The two tables on the Grids tab are randomly generated. They most likel
re-randomized...making my example harder to understand
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top