Hi all

I am working on a project where I have a list with multiple columns where I want to use a range of values in one column to determine the minimum in another column. It doesnt appear that I am able able to paste an example so adding an attached sample which shows the desired results. In this example, I want to use the lowest number in the "RVU" column for each set of data in the "COMBO" column and add the corresponding number in the "AMOUNT" column to the "SAVINGS" column (I manually added the numbers in the "SAVINGS" column to show what I am trying to do). The spread sheet has 106k lines so I can't manually do them all.

Thanks in advance

Attached Files

Example.xlsx (10.7 KB, 15 views)