F2셀 : (1) =IF(ISERROR(INDIRECT("B"&MATCH(E3,$A$3:$A$23,0)+2)),"",INDIRECT("B"&MATCH(E3,$A$3:$A$23,0)+2))
(2) =IFERROR(INDIRECT("b"&MATCH(E3,$A$3:$A$23,0)+2),"")
F19셀 : (1) =IF(ISERROR(INDIRECT("B"&MATCH(E19,$A$3:$A$23,0))+1+COUNTIF($A$3:$A$23,E19)),"",INDIRECT("b"&MATCH(E19,$A$3:$A$23,0)+1+COUNTIF($A$3:$A$23,E19)))
(2) =IFERROR(INDIRECT("b"&MATCH(E19,$A$3:$A$23,0)+1+COUNTIF($A$3:$A$23,E19)),"")
(3) =IF(ISERROR(INDIRECT("B"&MATCH(E19,$A$3:$A$23,0)+2+COUNTIF($A$3:$A$23,E19)-1)),"",INDIRECT("B"&MATCH(E19,$A$3:$A$23,0)+2+COUNTIF($A$3:$A$23,E19)-1))
(4) =IFERROR(INDIRECT("b"&MATCH(E19,$A$3:$A$23,0)+2+COUNTIF($A$3:$A$23,E19)-1),"")
'엑셀 (Excel) 활용' 카테고리의 다른 글
| 드롭다운 목록에서 선택 : 마우스 오른쪽 클릭 (0) | 2022.03.11 |
|---|---|
| 데이터 늘어나도 자동 계산 : offset, counta, sumproduct, sum, 이름정의, 배열식 (0) | 2022.03.11 |
| 동이름까지 추출 : left, find (0) | 2022.03.11 |
| 최초[최근] 거래일 : min, max, if, <> (0) | 2022.03.10 |
| sumproduct, n, isnumber, find, search, sum, 배열식 (0) | 2022.03.10 |