回复：一个Excel问题，可否拖拽产生数据

来源: 以前的笔名忘了 于 2010-07-23 12:16:51 [] [旧帖] [给我悄悄话] 阅读数 : (339 bytes)

anybody tried index function? try using this formula in sheet 2. In sheet2 cell A1 =index(Sheet1!$A$1:$A$10000,row(a1)*2-1), and then drag down to whatever number of cells you want. This is truely what you need. one simple formula, and values update as your sheet1 data changes. No sorting, no multiple pasting, no extra column needed.

请您先登陆，再发跟帖！