Hi All,
I hope someone can help me with this problem:
I want to count the unique text occurrences in column I but only if the value in column D is "Futures".
So far I managed to resolve part of the problem by "hard-coding" the range in the formula below:
SUMPRODUCT(--(FREQUENCY(MATCH('Data'!I29:I38,'Data'!I29:I38,0),ROW('Data'!I29:I38)-ROW('Data'!I29)+1)>0))
However, this should be changed so that it counts the unique values in Column I:I only if the value in column D is "Futures".
I have been wasting a disproportionate amount of time with this so I would really appreciate any ideas/help.
Thanks!
I hope someone can help me with this problem:
I want to count the unique text occurrences in column I but only if the value in column D is "Futures".
So far I managed to resolve part of the problem by "hard-coding" the range in the formula below:
SUMPRODUCT(--(FREQUENCY(MATCH('Data'!I29:I38,'Data'!I29:I38,0),ROW('Data'!I29:I38)-ROW('Data'!I29)+1)>0))
However, this should be changed so that it counts the unique values in Column I:I only if the value in column D is "Futures".
I have been wasting a disproportionate amount of time with this so I would really appreciate any ideas/help.
Thanks!