Based on the data visible in the attached image, I am trying to achieve the following:
I want table L5-N8 to automatically select two names from the table on the left with the lowest B #. However, while doing so, it should select one of each gender (M/F).
I am struggling to have all the above done. Any help would be greatly appreciated.