Find rows/groups with unique values and return

[rajamdade]

I am having 127 columns and 405 rows. A row consist of a group and column has individual (value of the cell consist of = "Unique accession | individual name or Species") as given below.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Groups[/TD]
[TD]Individuals
(Unique accession | individual name or Species)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group[ 0 ][/TD]
[TD]FN13|Olea_europaea[/TD]
[TD]FN13|Olea_europaea[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group[ 1 ][/TD]
[TD]EF17|Codium_arabicum[/TD]
[TD]EF18|Codium_arabicum[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group[ 2 ][/TD]
[TD]EF11|Codium_duthieae[/TD]
[TD]EF12|Codium_duthieae[/TD]
[TD]EF19|Codium_arabicum[/TD]
[/TR]
[TR]
[TD]Group[ 3 ][/TD]
[TD]JN37|Rhazya_stricta[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In result section, I need to have comments as below by matching the species column to the table:

If Same species are grouped together and not found in any other group then : TRUE

If Same species are grouped together but also found in other group then : AMBIGUOUS

If Multiple species are grouped together then : INCORRECT

If only one individual of representative species, this species in not in any other group then : SINGLETON

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Species list[/TD]
[TD]Comment (Result)[/TD]
[/TR]
[TR]
[TD]Codium_arabicum[/TD]
[TD]AMBIGUOUS
[/TD]
[/TR]
[TR]
[TD]Codium_duthieae[/TD]
[TD]INCORRECT[/TD]
[/TR]
[TR]
[TD]Olea_europaea[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]Rhazya_stricta[/TD]
[TD]SINGLETON[/TD]
[/TR]
</tbody>[/TABLE]

Kindly, suggest formula to comment as above.