[08] Sequence함수로 데이터있는행에만 No.자동채우기
Synopsis
B열에 데이터가 있을때만 동적으로 No.순서 채우기(SEQUENCE함수 응용)
You Might Also Like
![엑셀 실무] SEQUENCE 함수 | 1~1000번까지 간단하게 입력할 수 있습니다!](https://i.ytimg.com/vi/yLbC96NvmwE/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBpSU8OL-dPlifuCj0FfLLkOBRE9w)
![[엑셀] 데이터 입력에 따른 자동 행 번호 생성하기 / Automatic row number generation based on data input in Excel](https://i.ytimg.com/vi/x2cwn0A8jyQ/hq720_2.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGABwAcABBvABAfgBtgiAAoAPigIMCAAQARgTIFAofzAP&rs=AOn4CLAXLYDjPxEKKep4HF_Rr8qtmKjP5w)
Download Options
Choose a download method below. All links open in new tabs.
| Service | Features | Action |
|---|---|---|
| Ssvid |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
| SaveFrom |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.