回複：一個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.

請您先登陸，再發跟帖！