Active Customer Count per month

[Pra]

Hi All,

Need to calculate Active customer count per plant from a Sales report, need to exclude few types of customers like internal customers(they have specific range when customer number is created).

Column Headings are as below, report has 10000 trasactions.

Date Sales quantity Revenue Customer Number Plant Number Customer type(Internal/External)

Quick Response Appreciated.

Thanks.

 

[Somendra Misra]

Hi Pra,

Upload a sample file.

Regards,

 

[Pra]

Pls. find file attached. Need unique customer count only external customer type per plant for every month.
Let me know if you need any futher info.

Thanks for your help.

 

[Somendra Misra]

File is missing.

Regards,

 

[Pra]

Try now

 

[Somendra Misra]

See your file, yellow cells in the range AG2:AJ11 has solution. Check if this is right.

Regards,

 

[Pra]

Thanks Mate!!! working fine.
Appreciate your help.

 

[Somendra Misra]

Welcome back anytime Pra...

Regards,

 

[Pra]

Hi Somendra,

Formula is working fine. Problem is i have to do this report everymonth.
And they are like 18 plants and 13 month data, around 200000 lines.
Refreshing CSE formula everytime when the transactions are updated is very manual.
Is there any other way where the figures are updated dynamically? Pls. let me know.

Cheers