sheets_filter_formula
Google Sheets FILTER formula
Build a FILTER formula that shows the rows of a range matching 1-3 conditions (equals, contains, starts/ends with, one of, blank, number and date comparisons), optionally sorted and with a "no match" message. Returns the formula and a note.
输入参数joinorderrange必填separatorconditions必填skip_blankscase_sensitivecells_are_textno_match_message
sheets_rank_formula
Google Sheets RANK formula
Build a formula that ranks one column, with a choice of tie handling (min: 1,2,2,4; dense: 1,2,2,3; avg: 1,2.5,2.5,4; unique: 1,2,3,4) and optional ranking within a group column. mode "column" fills the whole column from one cell; mode "row" is a per-row formula to drag down.
输入参数modetiesgrouprange必填directionseparator
sheets_unique_formula
Google Sheets unique values formula
Build a formula for unique values: a UNIQUE list, COUNTUNIQUE, a value/count table, only the repeated values, or only the values that appear once.
输入参数modeorderrange必填separatorignore_caseskip_blanks
docs_match_case_replacement
Replace keeping the case of each match
Given matched texts and a replacement, return the replacement in the case shape of each match (ALL CAPS, Title Case, First letter, lower). The rule ReplaceKit uses for "Keep the case of each match" in Google Docs.
输入参数matches必填replacement必填
clean_text
Clean pasted text (spaces, breaks, quotes)
Run ReplaceKit cleanups on text (up to 50,000 characters), in the order given: double-spaces, space-before-punct, trailing-spaces, empty-paragraphs, line-breaks, nbsp, curly-quotes, straight-quotes. Returns the cleaned text and how many replacements each made.
输入参数text必填cleanups必填