hi there:
I need help with these for my work. I have attached the file.
So for values based on 'column A' and 'column B', i need unique count in 'column C'.
I couldn’t figure out a way for this. I can easily do it in pivot. But i need a formula for it.
So lets say for John he has 3 cause and 2 unique cause. I want 2 for John in 'column C' but only in one row for John. Not for all John's row.
In the attached file I have given an example, how I really want it!
I also have posted a possible solution. But that solution will post the value in every row instead of only the 1st row for 'column A' value
I really appreciate anyone helping me with this. Thanks in Advance.
Bookmarks