Column A is a list of text and number strings, many with duplicates

Column B is the groupings - numerical

Column C is the order - numerical

I need to check if all the duplicated strings in column A are 1 in the same grouping and 2 in sequential order without a gap

Example

A. B. C

A100. 1. 1

A200. 1. 2

A100. 1. 3

A300. 1. 4

A400. 2. 1

A400. 2. 2

A300. 2. 3

So in the above A100 would show there is an issue as it is in the same group but they are not sequential. A200 is fine. A300 has an issue as it is sequential but in different groups. A400 is fine.

I can add a working column of the strings with duplicates removed in on another sheet. I just cannot for the life of me work out how to get it to show if there is an issue or not per string based on the parameters. There can be 100s of duplications of the string in column A and they would all need to be in the same group and in sequential order to be classed as right.

I am using excel 365