I have a table(1) of data ("A1:B34"). Col "A" has names and Col "B" has values.
I wish to create another table(2) which only copies (names and values) data
from table(1) with values in col "B".
--
Bob

Hi,

Are you talking a Data Table or a Table of Data. Also what version of Excel
are you using? And why not just do Copy?


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Bob" wrote:

I have a table(1) of data ("A1:B34"). Col "A" has names and Col "B" has values.
I wish to create another table(2) which only copies (names and values) data
from table(1) with values in col "B".
--
Bob

Sorry Shane, having trouble with this site. As a reasult I have posted the
same question twice now, but to answer your question:

Copy col a and col b only if there is a value in col b.
ie

Table1
lindup 23
law 0
low 7

What I'm after in table is as follows:

Table2
lindup 23
low 7

I'm using excel 2003.
--
Bob


"Shane Devenshire" wrote:

Hi,

Are you talking a Data Table or a Table of Data. Also what version of Excel
are you using? And why not just do Copy?


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Bob" wrote:

I have a table(1) of data ("A1:B34"). Col "A" has names and Col "B" has values.
I wish to create another table(2) which only copies (names and values) data
from table(1) with values in col "B".
--
Bob