Here is a complete example that creates a table listing each occurrence of pairs of adjacent colors, including duplicates. In the example above, I'd like to obtain as a result that white was adjacent to blue and green was adjacent to gray (not necessarily how many times, but at least that they do appear). I would like to automate the creation of a histogram that, within a region of the spreadsheet, looks for adjacent text, and creates some kind of list of which colors appeared adjacent to one another. Note that it does not make a difference if one counts the adjacent text twice (for example, white and blue are adjacent, but also blue and white). Note that this configures two adjacent cell text instances, namely White - Blue and Green - Gray are adjacent. A tile has text markings on its borders, and the tiles exist in the spreadsheet with no overlaps.Īlso consider this example tile set, with the two tiles of the previous example arranged in a certain manner in 2D space. I have an excel spreadsheet with rectangular sets of cells.