Thread: Grouping Data by 3 Values

Hello All,

I have around 13000 colour measurements in L, a, and b colour space. We are trying to group them by similar colour which involves sorting the three columns as a set rather than independently. I've had some success with lists but this only does one colour at a time and involves manually setting tolerances.

I've attached an example of the data and the most simple result that would do the job, but even better than this would be a way of actually finding and grouping similar colours (say plus or minus 2 units on each value).

Hi,
May be a solution with pivot table : CIE a sorted from smallest to largest
I don't know if this will fit the whole database
Hope this helps
Best regards

Looking at your data, it looks like you could sort it by CEI a, then CEI b, then CEI L, all in smallest to largest order.

Hope this helps.

Pete

Hello Again All,

I hadn't realised you could have multiple levels of sorting. This allowed me to sort the data by colour and there is a colour difference equation which I applied to see if one product is the same as the one below and used an IF statement to return "same" or "different". I'm pretty sure from here it should be possible to group blocks labelled "same" as being the same colour but I'm still working on that part.

Thanks for your help

Jarvice