Skip to content

Instantly share code, notes, and snippets.

@seriwb

seriwb/excelmath

Created February 15, 2014 22:50
Show Gist options
  • Save seriwb/9026337 to your computer and use it in GitHub Desktop.
Save seriwb/9026337 to your computer and use it in GitHub Desktop.
Download ZIP
Excelの計算式サンプル（VLOOKUPとCOUNTIF）
Raw
excelmath
VLOOKUP
=IF(ISERROR(VLOOKUP(A31,Q$2:Q$99,1,FALSE)),"",VLOOKUP(A31,Q$2:Q$99,1,FALSE))
COUNTIF
=IF(NOT(M39="1"),(IF(COUNTIF(M$4:M39,M39)>1,"○","")),"")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment