New & Repeat customers

[madnanansari]

I have a retail sales database with the below information:

Date

Invoice No

Customer No

Sales

I need to find out

how much are the new customers in 2017 and 2018? 

How much are the repeat customers in 2018 from the list of new customers in 2017?

How much are the repeat customers in 2018 overall?

[isingh30]

Please share your data.

Thanks.

[MK_QSL]

Do you want to achieve at back end (script) or front end?

Can you provide few lines of sample data to work?

[madnanansari]

pls. find attached data in excel.

[madnanansari]

pls. find attached data in excel.

[MK_QSL]

Can you also provide output you are looking for in Excel?

This will make our job easy to help.

[madnanansari]

Output is simple.

it should show the new customer count and repeat customer count.