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.

Groups	Individuals (Unique accession | individual name or Species)
Group[ 0 ]	FN13|Olea_europaea	FN13|Olea_europaea
Group[ 1 ]	EF17|Codium_arabicum	EF18|Codium_arabicum
Group[ 2 ]	EF11|Codium_duthieae	EF12|Codium_duthieae	EF19|Codium_arabicum
Group[ 3 ]	JN37|Rhazya_stricta

<tbody>
</tbody>

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

Species list	Comment (Result)
Codium_arabicum	AMBIGUOUS
Codium_duthieae	INCORRECT
Olea_europaea	TRUE
Rhazya_stricta	SINGLETON

<tbody>
</tbody>

Kindly, suggest formula to comment as above.