Documentation M.CATEGORIZE
M.CATEGORIZE
M.CATEGORIZE lets you categorize one item into a pre-set list of category options.
M.CATEGORIZE takes an input to categorize, an array of category options, and 'context' texts to help with the categorization.
Examples
=M.CATEGORIZE("New York", {"rural","suburban","urban"})
=M.CATEGORIZE(B2, $A$2:$A$8, "Identify which risk category the contract should fall under")
Parameters
| Parameter | Type | Description |
|---|---|---|
| toCategorize | Text/Cell Reference | The file or text you'd like to categorize |
| Categories | Array | The category options you are trying to categorize into. Can be 1D or 2D array. |
| Context1 | Text/Cell Reference | The context you would like to provide for the categorization (instructions/examples) |
| [Context2] | Text/Cell Reference | Optional additional context entries. Continue adding information as needed |
Note: Context arguments are most commonly instructions or examples of past categorizations.