Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
data_analysis:excel [2023/05/17 02:35] – [Excel] prgram | data_analysis:excel [2025/07/07 14:12] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 14: | Line 14: | ||
- Multiple consolidation ranges" | - Multiple consolidation ranges" | ||
- 값을 행으로 넣기 | - 값을 행으로 넣기 | ||
+ | |||
+ | substitute text 여러개 한번에 하기 (LAMBDA & recursive function) : 이름정의 MultiReplace 로 | ||
+ | https:// | ||
+ | <code vb> | ||
+ | =LAMBDA(text, | ||
+ | </ | ||
+ | |||
+ | #DIVS 에러 처리 | ||
+ | <code vb> | ||
+ | =LET( x, sumifs( A2/B2 ), IF(x = 0, "", | ||
+ | =iferror(1/ | ||
+ | </ | ||