Data Table Question?
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
|