Count Unique Numbers if Names Match
Hi,
I can't see anything wrong with the formula. In what way are the numbers
'off a bit'?
Mike
"ryguy7272" wrote:
I have a summary sheet and a list of names, in ColumnC, on this sheet. Im
trying to figure out a way to find a match in names in ColumnC of Sheet2, and
then count unique numbers, in Column G, for these names. I was experimenting
with this:
=SUMPRODUCT((Sheet2!$C$2:$C$1000=C57)/(COUNTIF(Sheet2!$G$2:$G$1000,Sheet2!$G$2:$G$1000&" ")))
This comes pretty close, but the numbers are off a bit.
Any idea how to do this?
Thanks,
Ryan---
--
RyGuy
|