Provide Outcome based on three conditions.

Good Morning Team,

Hope all is well.

I am hoping this lovely forum could help me build a formula, which summarizes the two different scenarios i am encountering in my attached workbook.

1) If the "Comp Country (Column B) is different than "name Country" (Column E) then Column H should say move
"Re-Move Record to Equivalent "

For example
Column B = HK
Column E = UK
Column H = "Re-Move Record to Equivalent "

2)
In total there is 17 records, (6 = UK), (11 = USA). (Given that the UK Scenario is handled in point 1) we only need to compare records where the Comp country (Column b) and Name Country( Column e) are the same.
Out of those 11 records i need find who the majority Name for a given country/ For example in my scenario "RP" owns 10 out of the 11 records, and "TG" only owns one" therefore the record with "TG" needs to change from "TG" to "RP"