Results 1 to 4 of 4

Grouping Data by 3 Values

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2012
    Location
    Newcastle, England
    MS-Off Ver
    Excel 2007
    Posts
    8

    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).
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1