> ## Documentation Index
> Fetch the complete documentation index at: https://parabola.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Find min/max per row

> The **Find min/max** step calculates the minimum or maximum value across a range of columns.

## Input/output

Our input data shows how many items we sold on a given day.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/_Rd06MegMqgoEJ3a/images/calculate/find-min-max-per-row-input-input.png?fit=max&auto=format&n=_Rd06MegMqgoEJ3a&q=85&s=2229088be86a6c0febdbadeedca53613" alt="Input data showing daily item sales spread across multiple columns" width="1760" height="686" data-path="images/calculate/find-min-max-per-row-input-input.png" />
</Frame>

We can use this step to produce an output with a new column at the right side, called 'Most Sold in a Day,' which contains the maximum value in each row.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/_Rd06MegMqgoEJ3a/images/calculate/find-min-max-per-row-input-output.png?fit=max&auto=format&n=_Rd06MegMqgoEJ3a&q=85&s=65c7696c4e67314973fff551be9b3cc8" alt="Output data with a new 'Most Sold in a Day' column appended showing the max value across each row" width="1902" height="548" data-path="images/calculate/find-min-max-per-row-input-output.png" />
</Frame>

## Default settings

This step will automatically generate an 'Untitled' column after data is connected to it.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/_Rd06MegMqgoEJ3a/images/calculate/find-min-max-per-row-default-settings.png?fit=max&auto=format&n=_Rd06MegMqgoEJ3a&q=85&s=ab553dff88afd3c077e353c7801b2699" alt="Default settings panel auto-generating an Untitled column once data is connected" width="2428" height="1008" data-path="images/calculate/find-min-max-per-row-default-settings.png" />
</Frame>

## Custom settings

In the left-side toolbar, first choose in the 'Operation' dropdown menu whether our new column should show the 'Min' or the 'Max'.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/_Rd06MegMqgoEJ3a/images/calculate/find-min-max-per-row-custom-settings-1.png?fit=max&auto=format&n=_Rd06MegMqgoEJ3a&q=85&s=e101e86a145d559e03840a230683aa64" alt="Custom settings panel showing the Operation dropdown with Min and Max options" width="2428" height="1008" data-path="images/calculate/find-min-max-per-row-custom-settings-1.png" />
</Frame>

Then choose the columns to operate on by selecting values under 'Range Begin' and 'Range End'.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/_Rd06MegMqgoEJ3a/images/calculate/find-min-max-per-row-custom-settings-2.png?fit=max&auto=format&n=_Rd06MegMqgoEJ3a&q=85&s=d8fcf7d07e7838d8c452249e531f860e" alt="Custom settings panel showing Range Begin and Range End column selectors that define the columns to evaluate" width="2314" height="1372" data-path="images/calculate/find-min-max-per-row-custom-settings-2.png" />
</Frame>

After this, name your new column and click 'Show updated results' at the bottom to save.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/_Rd06MegMqgoEJ3a/images/calculate/find-min-max-per-row-custom-settings-3.png?fit=max&auto=format&n=_Rd06MegMqgoEJ3a&q=85&s=e6985fd5484df23100feca19e6f6048f" alt="Custom settings panel showing the new column name field and the Show updated results button" width="2416" height="1368" data-path="images/calculate/find-min-max-per-row-custom-settings-3.png" />
</Frame>

There is an advanced settings menu that you can expand. By default, the box is checked to 'Prefer numbers' when running your operation. You can deselect this option, but we recommend leaving it on.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/_Rd06MegMqgoEJ3a/images/calculate/find-min-max-per-row-custom-settings-4.png?fit=max&auto=format&n=_Rd06MegMqgoEJ3a&q=85&s=7200fb353d1c5e2f38e69775ffa6d66d" alt="Advanced settings menu showing the 'Prefer numbers' checkbox option toggled on" width="2430" height="1374" data-path="images/calculate/find-min-max-per-row-custom-settings-4.png" />
</Frame>

Your table will now have a column appended, displaying the minimum or maximum value per row, within the columns in your selected range.

## Related steps

* [Find maximum by group](/product/transform/find-maximum-by-group)
* [Find minimum by group](/product/transform/find-minimum-by-group)
* [Insert math column](/product/transform/insert-math-column)
* [Insert if else column](/product/transform/insert-if-else-column)
* [Insert calculated score column](/product/transform/insert-calculated-score-column)