Hui, thanks for the input, but what is a "manual" pivot table? I have managed to get the information I needed by doing a pivot table, with product, run number, and color all on the side, then counting the number of colors in each run with countif, but this is not a good solution for changing...
Hi,
I am trying to find a way to count unique values in a list, based on multiple criteria. The problem is, the list is thousands of rows long, and i need to count the unique values for EACH of several products, and each product will have a different range. I assume I have to somehow combine...