Using the ifmin function

[wheddingsjr]

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

[xor]

Will the lowest RVU number always be in the last row within a certain COMBO-set?

[wheddingsjr]

Hi xor

yes it will. I sorted it so that the lowest RVU will always be the last one within each combo set. Also, before the question gets asked, the lowest RVU does not always produce the lowest "AMOUNT" so regardless of the "AMOUNT" the lowest RVU is still desired.

[xor]

Take a look at the attached.

[wheddingsjr]

Thanks XOR, it worked perfectly. I appreciate the help.

[xor]

Thanks for your response.