Find missing combinations

[JOAO12]

Hi everybody,

My excel worksheet has a series of combinations (numbers "1", "2", "3", "4", "5", "6", "7", "8", "9" and "10" combined 4 by 4), but some combinations are missing and I need a macro to identify these missing combinations.

In order to make my problem understandable, the excel file attached shows the missing combinations in "red" (in fact these missing combinations shown in red are not displayed in the actual list).

So, I would like to ask your help to write a macro that shows the missing combinations in columns "H" to "K".

Thank you very much.

John

[kalak]

hi John,

assuming your data are as shown, in your columns C:F with no gaps but with the possible combinations in red not there (or indeed any of the possible combinations missing) then you can try the following code

Please Login or Register  to view this content.

[JOAO12]

Hi kalak,

Your macro works perfectly !

Thank you very much.

John