formaula to count the number of employees in a list containg duplicate names?

[tonywatsonhelp]

Hi Everyone,

so I need a way I can count the number for employess that worked for each week.

I have two columns of data

Column C is the week start date (i.e 18/09/2017)

Column J has the names of the employee loggen for that lines sale.

I'm trying to count how many different employees sold stuff for a given week

So the formula I'm looking for would be in English something like

Look down column C and see if any cells match date in cell B7, if they do count the sales person in column J but only if his not already made a sale that week! how can I do this I'm getting very confused

it seam such a simple thing to just tell me the number of different people selling on a given date? please save me!!!


thanks

Tony

 

[Aladin Akyurek]

You mean between 18/09/2017 and 22/09/2017, right?

 

[tonywatsonhelp]

HI,
It will only every be one date as the sales are recorded with the date as week starting,
so for example if in B7 I had the date "18/09/2017" it only has to lok for rows with that date

Thanks

Tony

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(1-($J$2:$J$400=""),IF($C$2:$C$400=$B7,MATCH($J$2:$J$400,$J$2:$J$400,0))),ROW($J$2:$J$400)-ROW($J$2)+1),1))

 

[tonywatsonhelp]

Thank you Aladin,
I can honestly say I would not have got that lol!

big help,
Thank you

Tony

 

[Aladin Akyurek]

Thank you Aladin,
I can honestly say I would not have got that lol!

big help,
Thank you

Tony

You are welcome.