I am a crocheter and I create drawings in Excel to turn into a list to follow e.g. 19 blue, 5 yellow, 76 blue, 2 white, 7 red, 2 blue.
I colour the cells (squares) in using the fill tool.
At the moment, I manually write out each row by highlighting and using the count tool at the bottom to tell me how many are in the black, but I have to do each block of colours one at a time; it's lengthy!
Can Excel return the information in text with the amount in a block, followed by the colour name, and then a comma e.g. a list? Colours will feature multiple times in each row, so using a count function isn't going to succeed.
I'd love some help with this as I have many patterns I would prefer to see written down! Thanks in advance.
Bookmarks