Using IF function to show highest value achieved across a range of cells

Hi apologies for the title, it is the best I could do to explain the problem!

Basically, I have a worksheet that shows test results for 6 separate tests. If an objective is met in a test then it is marked with an "X". If an objective is partially met then it is marked with a "/" and if it is not met then it is marked with a "." . I have now created a combined column where I want to collate whether an objective has been met at all across the 6 tests.

For e.g. if in the range H14:M14 there is an "X" then N14 should show "X". If there is no "X" but there is a "/" then N14 should show "/" and it there are neither values in the range then it will show "." .

I tried

Formula:

Please Login or Register  to view this content.

but it just came back with a formula error.

Thanks for any help.

Perfect, huge thanks!