General discussion

Locked

copy data of one column quickly

By Hunterzh ·
How to copy the data of one column quickly into another column?

In Excel 2000, we have several columns, for example, first column for serial number 1, 2, 3 , , , , , second column for name a, b, c, , , , , ,
seventh column with discontinuous serial number, 2, 5, 1, , , , , , eighth column for price 20, 30, 80, , , , , ,
now we want to copy the data of eighth column quickly into third column, according to serial number
In Access 2000, it is easy to realize by using a Query; but how to do it in Excel, using a function?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums