標籤
按函式、錯誤資訊或功能查詢教學。
#google-sheets (15)#excel (12)#data-cleaning (6)#xlookup (6)#vlookup (5)#arrayformula (4)#countif (4)#dates (4)#conditional-formatting (3)#countifs (3)#data-validation (3)#dynamic-arrays (3)#filter (3)#formulas (3)#google-sheets-errors (3)#iferror (3)#lookup-errors (3)#pivot-table (3)#query (3)#text-functions (3)#byrow (2)#comparison (2)#data-entry (2)#dropdown (2)#find (2)#importrange (2)#index-match (2)#ref-error (2)#regexextract (2)#sumifs (2)#sumproduct (2)#timesheet (2)#value-error (2)#value-function (2)#age (1)#approximate-match (1)#array-constants (1)#char-160 (1)#charts (1)#checkboxes (1)#conditional-counting (1)#datedif (1)#datevalue (1)#dependent-dropdown (1)#duplicates (1)#duration (1)#edate (1)#email (1)#excel-tables (1)#getpivotdata (1)#holidays (1)#ifna (1)#lambda (1)#map (1)#mod-function (1)#names (1)#networkdays (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)#refresh (1)#regex (1)#spill-error (1)#split (1)#structured-references (1)#sum (1)#text (1)#text-to-columns (1)#textjoin (1)#time (1)#time-calculations (1)#trackers (1)#trim (1)#troubleshooting (1)#workday (1)