I have a table with several columns and rows.
The columns are divided in two groups:
North: 1 to 4 & 9 to 12
South: 5 to 8
I need a code which report, on second sheet, the name (or names in case of same value) who has the lower numer for first group (North) and the the name who has the lower numer for second group (South).
In case is the same name (same row) of north, for south group I need the second lowest number.
I attach an example with the expected result