Hi, I'm trying to use a formula to automate finding unique clients in a certain time period.
If Column A is all clients, Column B is dates, I'd like to get the number of unique clients we've done business with in "x" month.
I have this formula to pull only unique values but having trouble incorporating the date piece of it.
{=SUM(IF(1/COUNTIF(A1:A10,A1:A10)=1,1,0))}
I also have this fomrula to pull the distinct values if it's of any help.
{=SUM(IF(B2:B7<>"",1/COUNTIF(A1;A10, A1:A10), 0))}
Any help would be much appreciated!!!
Bookmarks