새로 알게 된 기능
=TEXT(B2, "mmmm")
Convert a number into text according to a specified format.
In this case, you want to list the months of the year. You can use the format “mmmm” for the full name of the month.
=COUNTIF('raw data'!G:G,A2)
Count how many items in a range of cells meet a given criterion.
In cell B2, type =COUNTIF('raw data'!G:G,A2).
The first entry ('raw data'!G:G) refers to the range where you are counting the data. The range is located on your raw data sheet ('raw data'!) and includes all column G (G:G). This column contains the data for months.
The second entry (A2) refers to the criterion you want to count. In this case, it’s “January,” the value in cell A2 of your summary data sheet.
The function will tell you how many times January (the criterion) appears in the Date column (the range).
=DATEDIF(start_date, end_date, unit)
Unit
"Y" : The number of complete years in the period
"M" : The number of complete months in the period
"D" : The number of days in the period
"YM" : The days and years of the dates are ignored
"YD" : The years of the dates are ignored
https://support.microsoft.com/en-us/office/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c
DATEDIF function - Microsoft Support
Explore subscription benefits, browse training courses, learn how to secure your device, and more. Microsoft 365 subscription benefits Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge. Ask the Microsof
support.microsoft.com
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")
Import a range of cells from a specified spreadsheet.
https://support.google.com/docs/answer/3093340?hl=en&ref_topic=9199554
IMPORTRANGE - Google Docs Editors Help
Imports a range of cells from a specified spreadsheet. Sample Usage IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10") IMPORTRANGE(A2,"B2") Syntax IMPORTRANGE(spreadsheet_url, range_string) spreadsheet_url - The URL of t
support.google.com
=IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",1)
Import data from a table or list within an HTML page.
https://support.google.com/docs/answer/3093339?hl=en&sjid=2753927018437613366-AP
IMPORTHTML - Google Docs Editors Help
Imports data from a table or list within an HTML page. Sample Usage IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4) IMPORTHTML(A2,B2,C2) Syntax IMPORTHTML(url, query, index) url - The URL of the page to examine, including protoco
support.google.com
=VLOOKUP(102, A2:C7, 2, FALSE)
Use VLOOKUP when you need to find things in a table or a range by row.For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.
=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
VLOOKUP function - Microsoft Support
You can use VLOOKUP to combine multiple tables into one, as long as one of the tables has fields in common with all the others. This can be especially useful if you need to share a workbook with people who have older versions of Excel that don't support da
support.microsoft.com
=IFNA(#N/A, "Does not exist")
Replace the #N/A error with something more descriptive, like "Does not exist."
=PRODUCT(A1, A2) = A1 * A2
=PRODUCT(A1:A3, C1:C3) = A1 * A2 * A3 * C1 * C2 * C3
Multiply the numbers given as arguments.