hello,
my table looks like this:
i would like to use formulas to count the number of unique ids, based on org and recognition type. end result would look like this:
notice that id Z0044444, in org SHS SP, is only counted once in the point based reward column, even though this id received two separate awards. i only want it counted once. same with id Z0088888, in org SHS MM, in the point based reward to my direct reports column.
i've tried COUNTIFS combined with a SUMPRODUCT but that doesn't seem to be doing the trick. happy to post a sample workbook if that makes it easier.
thank you in advance for any tips.
my table looks like this:
i would like to use formulas to count the number of unique ids, based on org and recognition type. end result would look like this:
notice that id Z0044444, in org SHS SP, is only counted once in the point based reward column, even though this id received two separate awards. i only want it counted once. same with id Z0088888, in org SHS MM, in the point based reward to my direct reports column.
i've tried COUNTIFS combined with a SUMPRODUCT but that doesn't seem to be doing the trick. happy to post a sample workbook if that makes it easier.
thank you in advance for any tips.