I'm bashing my head against a wall. I feel like the answer is so obvious but it's eluding me. Included is a screenshot of an example.
Basically I need to compare two columns, and say how many times for Column A there is a unique value in Column B. In the screenshot I've attached, Columns D and E show my ideal output, but how do I write a formula that will display that? Aaaaah.
Thank you.
Basically I need to compare two columns, and say how many times for Column A there is a unique value in Column B. In the screenshot I've attached, Columns D and E show my ideal output, but how do I write a formula that will display that? Aaaaah.
Thank you.