Scenario: AA1:AD1 are the same color, once you get to AE1 it is a different color
Code right now: Counts how many cells in range are the same color as AA1, then counts how many cells in range are the same color as AB1 (same answer), AC1(same answer), AD1(same answer), AE1 and so on. Since the first few cells are the same color, my function is giving the same answer over and over.
What I'd like it to do: Give the total number of cells in range with one color, then the next color, etc instead of retrieving the same total over and over for similar colored cells
Bookmarks