Find and Flag Missing Data Pair in a range of repeating data segments.

[mgcarino14]

Hi Experts,
I need help with creating a VBA macro that would flag the missing pair of data in a given range.
See data below - Pair "1" and "C" is missing in data set 3.
Thank you.


ColA ColB Expected Result
1 A Ok
1 B Ok
1 C Missing Data Pair in Range A9:A11
1 D Ok

2 E Ok
2 F Ok
2 G Ok
2 H Ok

1 A Range has missing data Pair
1 B Range has missing data Pair
1 D Range has missing data Pair

1 A Ok
1 B Ok
1 C Missing Data Pair in Range A9:A11
1 D Ok

2 E Ok
2 F Ok
2 G Ok
2 H Ok