急!!!!!!!!EXCEL根據員工名傳回一年內的年假日期

try this:

設 A1-A12 為姓名
設 B1-B12 為年假由
設 C1:C12 為年假至
設 D1:D12 為天數 --> D1=C1-B1 (公式往下拉)
在 F2 輸入姓名
G2=IF(COUNTIF(A$1:$A$12,$F$2)<ROW()-1,"",OFFSET(B$1,SMALL(IF(ISNUMBER(FIND($F$2,$A$1:$B$12)),ROW($1:$12)),ROW(1:1))-1,))
G2打完公式後同時按 SHIFT + CTRL + ENTER 會見到 { }
公式往右拉及下拉便成

You can make use of 'Filter' to extract the data you want.

.............Col. A........Col. B..........Col. C
Row 1...Name.........Dept............Date of Leave
Row 2...Steven........Logistics......2008/1/1
Row 3...Mary..........Finance........2008/1/3
Row 4...Steven........Logistics......2008/3/2
Row 5...Billy...........Technical.....2008/4/5

You click on cell A1 'Name' then select Data > Filter > Autofilter from top menu bar, you will see an up side down triangle marked on the cell, just click on it and select your criteria for extracting data.