Hi all,
Can anyone help me out with the following:
1. Select name in L6 of a particular gender
2. Excel then returns a name of the opposite gender with the lowest B. #.
However, I'm struggling to get a formula to work properly.
Any help would be greatly appreciated. As you've probably already guessed, the formula should feed on data on from the table to the left.