I have sets of six numbers.

I have selected all possible groups of three from each set of six numbers.

I have to cross examine between sets in order to identify where there are similarities.

This means if I find a set of three numers (eg 15,60,75) in one set of six numbers (eg 15,20,50,60,65,75), I have to inspect all other sets of six numbers to try and find the same.

I have to do this for all possible sets of three numbers from all sets of six.

on the worksheet that I have attached, I have separated out the "sets of three" for visual purposes, as I also have to be able to look through this list like this.

I would like to colour the cells of similar "sets of three numbers" the same colour. But each set pair found after that would require a different colour to be applied.

Would it be possible (without altering the cells of the original sets of six) to go through all of these sets of three numbers and identify other identical sets ?

select-groups-of-3.xls
allthe sets of 3 will be highlighted, but maybe your real data is different.Open in new window