M
Melody
I'm trying to get the unique entries from NAME for a month . (Q1 refer to for year), (G2 refer to for no. of month)
Can you please take a look tell me what I'm doing wrong. This is what I have
{=SUM(--(((PAYTYPE=$F$2)+(PLACE=$E$2))>=(($F$2<>"")+($E$2<>""))),--(YEAR(DOS)=$Q$1),--(MONTH(DOS)=G2),--(DOS<>""),(IF(FREQUENCY(IF(LEN(NAME)>0,MATCH(NAME,NAME,0),""),IF(LEN(NAME)>0,MATCH(NAME,NAME,0),""))>0,1)))
Thanks for any help.
Can you please take a look tell me what I'm doing wrong. This is what I have
{=SUM(--(((PAYTYPE=$F$2)+(PLACE=$E$2))>=(($F$2<>"")+($E$2<>""))),--(YEAR(DOS)=$Q$1),--(MONTH(DOS)=G2),--(DOS<>""),(IF(FREQUENCY(IF(LEN(NAME)>0,MATCH(NAME,NAME,0),""),IF(LEN(NAME)>0,MATCH(NAME,NAME,0),""))>0,1)))
Thanks for any help.