Data filtering and sorting

[Feras95p]

Dear all,

I need your help in that, I have an excel file which contains two columns the first column is the date of the order and the second column is the mobile phone of the customers that have ordered. What I want is that I want to now how many new customers that order from 1/1/2020 till 18/1/2020 and how many customers that have already ordered before 1/1/2020 and ordered again in 2020. I can't attached the excel file because of the privacy so any help in that please?

Thanks in advance for your kind support.  

[afv2688 · Accepted solution]

Hello @Feras95p,

Would this work for you? I used letters instead of phone numbers:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[Jonathan-Sherman]

Hi @Feras95p,

Just thought i'd also add my own take:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan