COUNT Uniques names- Multiple conditions

[Dan_K_2014]

Hello All,

I am trying to build a formula to count Unique people names in Column "G" with a multiple conditions. Conditions are:
1. By type in Column "K".
2. By period of time in Column "J".
3. By Location in column "D".

We are looking now at a Analysis sheet.
When I am changing the dates in F7, 8 and G7, 8; and selecting the location name in C4,

In all F and G 12:27 I should have a number of unique (not repeated) names of people from column "G" related to the selected time period and location number.

Thank you.

 

[Somendra Misra]

Hi,

See the file and confirm back.

Regards,

 

[Dan_K_2014]

Hello Somendra,

Thank you for your reply. Would you please explain me what you did with "Table" in a sheet "CombData"?
My data file "CombData" is about 200,000 lines.

My e-mail kazdima [at] yahoo [dot] ca.

 

[Dan_K_2014]

Also,

when there is "zero' amount in column "L", the number of unique names in column "G" should be counted.

Thank you.

 

[Dan_K_2014]

Sorry, Should NOT be counted.

 

[Somendra Misra]

@Dan_K_2014

Will update something on this by tonight.

Regards,

 

[Dan_K_2014]

Thank you. And formula runs very slow... Is it only one way how to solve my task?

 

[NARAYANK991]

Hi Dan ,

Over 200,000 lines , no array formula is going to be fast.

The only way you can speed it up is either by using helper columns or by using VBA.

Narayan

 

[Dan_K_2014]

Hi Narayan,

Yes, you are I right...
Can you help me to write a Macro?
Thank you.

 

[Nebu]

Hi:

I am not sure how fast it is going to run in a bigger data set. I have put a macro to do the same.

Thanks

 

[Dan_K_2014]

Thank you very much, Nebu.