# [Excel] ๋ฌธ๋ฒ•

=COUNTIFS(D11:D19,"๊ฐœ์„ ",C11:C19,"์ง„ํ–‰์ค‘") =COUNTIFS(D11:D19,"๊ฐœ์„ ",C11:C19,"์™„๋ฃŒ") =COUNTIFS(D11:D19,"๊ฐœ์„ ",C11:C19,"๋ณด๋ฅ˜")

=COUNTIFS(B2:B15,">"&"1988-1-1",B2:B15,"<"&"1998-1-1")

# [Excel] ์—‘์…€๋กœ ์ธ์„œํŠธ๋ฌธ ๋น ๋ฅด๊ฒŒ ๋งŒ๋“ค๊ธฐ

=A2&"''"&B2&"_"&C2

# excel

=VLOOKUP(A5,E:E,1,FALSE) =",'"&A6&"'"

# [PowerPoint] ํ‘œ ํ…Œ๋‘๋ฆฌ ์„  ์ƒ‰ ๋ณ€๊ฒฝ

๋””์ž์ธ > ํŽœ์ƒ‰ ์ƒ‰๊น”์„ ํƒํ›„ ํด๋ฆญ๊ธˆ์ง€ > ํ…Œํˆฌ๋ฆฌ ์›ํ•˜๋Š” ํ…Œ๋‘๋ฆฌ ์„ ํƒ

Last Updated: 4/13/2025, 11:14:44 PM