|
 , Hit : 1036 |
|
|
||||
|
|||||
|
|
|
- File #1 : 엑셀_예제2.xlsx(11.3 KB), Download : 11 |
|
엑셀 함수만으로 해봤어요.. =INDEX($B$2:$F$6,$A2+IF(AND($A2>=$H$2,B$1=$H$4),1,0),IF($A2<$H$2,B$1,IF(B$1=$H$4,1,IF(AND($A2=$H$2,B$1<$H$1),B$1,B$1+1))))  |
|
||||||||
|
||
|
||
| ||
|