View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jman Jman is offline
external usenet poster
 
Posts: 110
Default Formula help! counting one visit clients

Ok .. this is how it finally worked.. Your formula did help though.

I used your formula up to this point.
In C1 i copied it down.

=(ISNA(VLOOKUP(B1,A:A,1,False)))


In D1 copied down
=IF(C1=TRUE,"1",0)


Then i just sum the 1's as you suggested.

Thanks for the info.