Data Table Question?
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 |
Data Table Question?
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 |
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 |
All times are GMT +1. The time now is 06:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com