Excel求教！ - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Business - 商学院

Excel求教！

Excel求教！# Business - 商学院

m*o2008-02-08 08:02

1 楼

Excel求教！
有两个Workshee：
Worksheet 1, 有columns A, B, C, D和lines A1, A2, A3, A4, A5, 每line分别有
column B，C， D。
Worksheet 2, 有column A, B, C, D 和lines A1, A3, A5
请教如何把Worksheet 1里lines A1, A3, A5 column B的数值import到Worksheet 2里
相对应的lines A1, A3, A5？
谢谢！

S*32008-02-08 08:02

2 楼

write a "=" function, refer to the cell you want. might have to use $.
EZ, just have a try.

【在 m******o 的大作中提到】

: Excel求教！
: 有两个Workshee：
: Worksheet 1, 有columns A, B, C, D和lines A1, A2, A3, A4, A5, 每line分别有
: column B，C， D。
: Worksheet 2, 有column A, B, C, D 和lines A1, A3, A5
: 请教如何把Worksheet 1里lines A1, A3, A5 column B的数值import到Worksheet 2里
: 相对应的lines A1, A3, A5？
: 谢谢！

m*o2008-02-08 08:02

3 楼

It didn't work.
The problem is worksheet 1 has, say 500 lines, worksheet 2 has, say 400
lines. Some lines on worksheet 1 don't exist on worksheet 2, and some lines
on worksheet 2 don't exist on worksheet 1.

【在 S*3 的大作中提到】

: write a "=" function, refer to the cell you want. might have to use $.
: EZ, just have a try.

S*32008-02-08 08:02

4 楼

如果你要得lines是有一定pattern的，write a function
如果是比较random从500里挑400，forget it. Do it manually.
如果有其他选择条件using other columns，do it in Access.
不好意思，你的问题还是比较泛泛，没法子给你更细致的回答。have a try

It didn't work.
The problem is worksheet 1 has, say 500 lines, worksheet 2 has, say 400
lines. Some lines on worksheet 1 don't exist on worksheet 2, and some lines
on worksheet 2 don't exist on worksheet 1.

【在 m******o 的大作中提到】

: It didn't work.
: The problem is worksheet 1 has, say 500 lines, worksheet 2 has, say 400
: lines. Some lines on worksheet 1 don't exist on worksheet 2, and some lines
: on worksheet 2 don't exist on worksheet 1.

m*o2008-02-08 08:02

5 楼

没有pattern，不会access, wuwu

lines

【在 S*3 的大作中提到】

: 如果你要得lines是有一定pattern的，write a function
: 如果是比较random从500里挑400，forget it. Do it manually.
: 如果有其他选择条件using other columns，do it in Access.
: 不好意思，你的问题还是比较泛泛，没法子给你更细致的回答。have a try
:
: It didn't work.
: The problem is worksheet 1 has, say 500 lines, worksheet 2 has, say 400
: lines. Some lines on worksheet 1 don't exist on worksheet 2, and some lines
: on worksheet 2 don't exist on worksheet 1.

S*32008-02-08 08:02

6 楼

well, a VB Macro in Excel will work.
Or try to use other stat applications if it doesn't require to keep the code
in Excel. Like STATA etc. EZ than access to learn.
Or learn access.
Otherwise, 默哀，have to do it manually as far as I know. hope there aren't
that many.

【在 m******o 的大作中提到】

: 没有pattern，不会access, wuwu
:
: lines

z*k2008-02-08 08:02

7 楼

use vlookup()

lines

【在 m******o 的大作中提到】

s*l2008-02-08 08:02

8 楼

I can't understand your question....post some examples here and I might be
able to help

g*e2008-02-08 08:02

9 楼

vlookup!