Extracting values from a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table which shows a tick in the cells where a combination of both
the column and row headings is valid. I want to extract from this table one
record for each valid combination of by concatenating the column heading and
row heading e.g.

Table looks like this:

A B C
1 x x
2 x
3 x x

Result required:

A1
B2
B3
C1
C3

Can anyone out there help as I am completely stuck as to how to go about this?

Many thanks in anticipation

PS Using Excel 2003 on XP Professional
 
See one response at your thread in .misc.

Rob said:
I have a table which shows a tick in the cells where a combination of both
the column and row headings is valid. I want to extract from this table one
record for each valid combination of by concatenating the column heading and
row heading e.g.

Table looks like this:

A B C
1 x x
2 x
3 x x

Result required:

A1
B2
B3
C1
C3

Can anyone out there help as I am completely stuck as to how to go about this?

Many thanks in anticipation

PS Using Excel 2003 on XP Professional
Click to expand...
 

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

Similar Threads

Extracting values from a table 2
Macro to concatenate columns 1
Need to find the value within a matrix / table based on two other values 1
Calcutate SUM of column in first blank row 5
Reconstructing a table with Arrays 1
Fn = Cn * En 2
Excel Help to copy information from one row at a time to another sheet 1
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1

Back
Top