Find top values in range, if top value already exists in specific row, enter second value

Hi all

I need to get the top value from a list of 12 possible responses, check the value does not already exist in a specific row, if it does, then enter the second top value (or third, fourth etc. until it is a unique value in the row), else enter it as a value.

E.G:
Value 1 Value 2
Value 1 Value 2
Value 1 Value 1
Value 2 Value 1
Value 3 Value 3
Value 1 Value 1

Value 1 Value 2

Because Value 1 in the first column is taken, Value 2 is substituted as it is the second most common value.
I've attached a desensitised example which will hopefully explain a bit more what I'm trying to achieve.

I'm currently using a formula to get the top value (index mode match), manually going through the answers and omitting duplicate values for the second or third highest

Any help with this is greatly appreciated, and if you need any further information, please let me know

Thanks

EDIT: Updated the attachment as I realised columns 1 and 6 we're identical.

EDIT 2: I've managed to make some code to get this to work - I have 12 instances of this code in total, running one after the other but for future reference here is one example of it:

Please Login or Register  to view this content.