> For the complete documentation index, see [llms.txt](https://docs.tabula.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/modeif.md).

# ModeIf

Gets the most common value in the column filtered by the condition

```mathematica
ModeIf(colum1, colum2 > colum1) → 5
ModeIf(colum2, Startswith(colum3, "A")) → 10
```

#### Inputs

`ModeIf(column, [condition])`

* `column` - A column to get the mode value for
* `[condition]` - **\[optional]** - Condition to filter values in the column