Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
data_analysis:excel [2023/06/21 04:43] – [Excel] prgramdata_analysis:excel [2025/07/07 14:12] (current) – external edit 127.0.0.1
Line 15: Line 15:
 - 값을 행으로 넣기 - 값을 행으로 넣기
  
-substitute test 여러개 한번에 하기 (LAMBDA 사용)+substitute text 여러개 한번에 하기 (LAMBDA & recursive function: 이름정의 MultiReplace 로
 https://www.ablebits.com/office-addins-blog/excel-find-replace-multiple-values/ https://www.ablebits.com/office-addins-blog/excel-find-replace-multiple-values/
 +<code vb>
 +=LAMBDA(text, old, new, IF(old="", text, MultiReplace(SUBSTITUTE(text, old, new), OFFSET(old, 1, 0), OFFSET(new, 1, 0))))
 +</code>
 +
 +#DIVS 에러 처리
 +<code vb>
 +=LET( x, sumifs( A2/B2 ), IF(x = 0, "",x) )
 +=iferror(1/(1/sumifs( A2/B2 )) , "")
 +</code>
  
  
  • data_analysis/excel.1687322631.txt.gz
  • Last modified: 2025/07/07 14:12
  • (external edit)