标签
按函数、错误信息或功能查找教程。
#google-sheets (8)#excel (6)#data-cleaning (5)#arrayformula (4)#countif (3)#countifs (3)#dynamic-arrays (3)#google-sheets-errors (3)#query (3)#byrow (2)#comparison (2)#dates (2)#filter (2)#importrange (2)#ref-error (2)#sumproduct (2)#timesheet (2)#vlookup (2)#age (1)#approximate-match (1)#array-constants (1)#char-160 (1)#checkboxes (1)#conditional-counting (1)#conditional-formatting (1)#data-entry (1)#data-validation (1)#datedif (1)#datevalue (1)#dependent-dropdown (1)#dropdown (1)#duplicates (1)#duration (1)#edate (1)#email (1)#excel-tables (1)#lambda (1)#lookup-errors (1)#map (1)#mod-function (1)#non-breaking-space (1)#number-format (1)#numbers-stored-as-text (1)#numbervalue (1)#or-logic (1)#overnight-shift (1)#permissions (1)#progress-bar (1)#regex (1)#regexextract (1)#spill-error (1)#structured-references (1)#sum (1)#sumifs (1)#text-functions (1)#text-to-columns (1)#textjoin (1)#time (1)#time-calculations (1)#trackers (1)#trim (1)#value-error (1)#value-function (1)#xlookup (1)