Find minimum value in 2 columns based on multiple criteria

[thedunna]

In my Test Worksheet I am looking to auto populate the column shaded in gray with a 1 or a 2 based on the following rules:

1. FIRST take the minimum value under the letter "G" and give that a value of "1".
2. Not using the value under the letter "N" next to the value used under "G", take the minimum value under "N" from the remaining 3 numbers and give that a value of "2".

If there are duplicate minimum numbers under "G", use the one which allows you to use the smallest number under "N". I hope this is doable. I manually entered the 1's and 2's in the first 9 instances to show what the results should be.

Thank you...

[AliGW]

This is the same query as the other thread, just in a different guise. The solution will be practically the same. I’m closing this thread so you can ask this in the other thread, as it is merely a twist on what is already there.

Thread closed.

[AliGW]

The original thread is here: https://www.excelforum.com/excel-for...al-format.html