IF rows in column A match, then take the smallest value in column B

Question

I currently have a set of data where Column A is a list of names, and Column B is a value (i.e. 4, 0, 25). I need to have the workflow set up so that if there is a duplicate value in Column A (i.e. John B. Scott is listed three separate times), it takes the lowest value for that name from Column B.

Any suggestions? I've tried playing with multi-row formulas, formulas, and filters and searching the community for a similar scenario but no success.

ravisharma · Accepted Answer

Hi @ew87

Could you try with attached workflow, this might help in getting lowest value from column B.

This one is without using Multi row tool.

Hope this helps.

Thanks.

danilang · Accepted Answer

Hi @ew87

Here's what you're looking for.  The Summarize finds the min value and Count by Name.  That's joined back to the original data putting the respective min and count on each row and the formula tool does the rest.   I set the formula tool to create a new column(NewValue), but you can set it to replace the Value column instead.

The RecordId is there to be able to restore the original order after the join tool messes it up.

Dan