Rediska
Member
Dear Excellians,
Please help!
How can I count unique values in a list with correspondent specific value from column B?
To count unique cells in column A I use this formula and it works perfectly (referencing to another worksheet):
{=IFERROR(SUM(IF(FREQUENCY(IF(LEN(INDIRECT("'"&E7&"'!$a$11:$a$8000"))>0,MATCH(INDIRECT("'"&E7&"'!$a$11:$a$8000"),INDIRECT("'"&E7&"'!$a$11:$a$8000"),0),""), IF(LEN(INDIRECT("'"&E7&"'!$a$11:$a$8000"))>0,MATCH(INDIRECT("'"&E7&"'!$a$11:$a$8000"),INDIRECT("'"&E7&"'!$a$11:$a$8000"),0),""))>0,1)),"")}
How can I modify/add a condition based on a value from another column? (please see attached).
Thanks a lot!
Rediska
Please help!
How can I count unique values in a list with correspondent specific value from column B?
To count unique cells in column A I use this formula and it works perfectly (referencing to another worksheet):
{=IFERROR(SUM(IF(FREQUENCY(IF(LEN(INDIRECT("'"&E7&"'!$a$11:$a$8000"))>0,MATCH(INDIRECT("'"&E7&"'!$a$11:$a$8000"),INDIRECT("'"&E7&"'!$a$11:$a$8000"),0),""), IF(LEN(INDIRECT("'"&E7&"'!$a$11:$a$8000"))>0,MATCH(INDIRECT("'"&E7&"'!$a$11:$a$8000"),INDIRECT("'"&E7&"'!$a$11:$a$8000"),0),""))>0,1)),"")}
How can I modify/add a condition based on a value from another column? (please see attached).
Thanks a lot!
Rediska