Find min/max per row

Input/output

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

Input data showing daily item sales spread across multiple columns

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.

Output data with a new 'Most Sold in a Day' column appended showing the max value across each row

Default settings

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

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’.

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

Custom settings panel showing Range Begin and Range End column selectors that define the columns to evaluate

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

Custom settings panel showing the new column name field and the Show updated results button

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.