Get warning when Mutually Exclusive is not fulfilled Macro Wanted VBA

[carpediem_3112]

Hey guys,

Exclusive Rules.xls

I'd appreciate if you help build a macro with a series of warning, depending on meeting (or not) certain conditions.

I have a table Exclusive Rules.xls, where I have 3 groups of columns:

1. First group represent some INFO which, if repited rows (2=3=4), can vary only in last column
2. Second group represents a series of TYPES (R1, R2, R3)
3. Third group represents a series of PLACES (101, 202, 303)

Warning 1: Mutually exclusive
Where for each info I can get a number combinations INFO/TYPES/PLACES (2/R1/101) which are mutually exclusive, i.e. assuming that rows 2 and 3 are the same with the last column different:

1. If 2/R1/101 exists, 3/R2/101 CAN't exist, therefore, I must get a warnning (you repeated 101)
2. If 2/R1/101 exists, 3/R1/202 CAN't exist, therefore, I must get a warnning (you repeated R1)

Warning 2: Repeated INFO
When 2 rows have the exact same INFO (first group columns) in ALL columns. Repeated rows could OR couldn't be consecutive, i.e. 2=3 OR 2=452


Warning 3: No Possible TYPE/PLACE combination
I can tell if a combination is given because I use "1,0 system" (better ilustrated with attachment Exclusive Rules.xls). If for any reason you have all 0-zeros in TYPE column group AND/OR in PLACE column group, a warning should be set.


Warning 4: Succesfull Table
If no error encountered, this should be trigerred, indicating that the macro run successfully.

Thank you very much. I hope you can help me.



Exclusive Rules.xls

[carpediem_3112]

Anyone has an idea?