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
Bookmarks