Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Random table of data - need to find every cell that contains specific data
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.
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. |
#2
|
|||
|
|||
.
Sample File MISSING <<<<< .
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i find specific data in a cell and its colocated cell data | Excel Worksheet Functions | |||
VBA code to find specific data by name. Get average. Put in cell. | Excel Programming | |||
Macro to find specific data in a cell, then delete that row on down | Excel Programming | |||
Search for a number in a table and return data of a specific cell | Excel Discussion (Misc queries) | |||
Using macro to add data in specific cell within a table | Excel Programming |