Spreadsheet: 748372d1632129717-creating-customer-segments-using-ms-excel-creating-customer-segments-using-ms-excel
Sheet: Customer List

Last Name | First Name | Date Entered | Total Spent | Tot Orders | [NAME] | Date Entered | [NAME] | Customer Type
Dubovska | [NAME] | 12/22/2013 | $0.00 | 0 | 1900-01-01 00:00:00
Chakir | Nail | 12/22/2013 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Kai | 12/23/2013 | $0.00 | 0 | 1900-01-01 00:00:00
Cristante | Filippo | 12/26/2013 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Sania | [NAME] | $0.00 | 0 | 1900-01-01 00:00:00
Arsalan | [NAME] | 12/30/2013 | $0.00 | 0 | 1900-01-01 00:00:00
Banglatex | Mauro | 12/31/2013 | $0.00 | 0 | 1900-01-01 00:00:00 |  |  |  | Group A: Loyal Customers (Customers who have ordered thrice or more in the past 2 months)
[NAME] | Agnese | 12/31/2013 | $0.00 | 0 | 1900-01-01 00:00:00 |  |  |  | Group B: Lost Customers (Customers who used to order frequently but have had no orders for the last 3 months)
Sobhan | Farzana | 2014-02-01 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00 |  |  |  | Group C: Neutral Customers (Customers who have ordered maximum once or twice in the last 2-3 months)
Shipon | Enayet | 2014-04-01 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
Chowdhury | [NAME] | 2014-07-01 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00 |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1359541-creating-customer-segments-using-ms-excel.html
Kamal | [NAME] | 2014-09-01 00:00:00 | $2,662.50 | 3 | 2021-12-09 00:00:00
McCallum | Calum | 2014-09-01 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
Athar | Abrar | 2014-11-01 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
Kibria | Shovon | 2014-11-01 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
Hussain | Beanus & Jens | 2014-11-01 00:00:00 | $23,032.50 | 13 | 2021-11-05 00:00:00
Larrieu | Pierre-Jean | 1/13/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Bretzfield | [NAME] | 1/13/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Nawshin | 1/13/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Hussain | [NAME] | 1/15/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Mizan | Major | 1/15/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Kuddus | Ulfath | 1/15/2014 | $7,782.50 | 6 | 2021-07-08 00:00:00
[NAME] | Tanveer | 1/15/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Sattar | Atif | 1/16/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Shamsuddoha | Reem | 1/16/2014 | $2,182.50 | 2 | 2021-10-07 00:00:00
Yates (Home) | [NAME] | 1/17/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Tosi | Luca | 1/17/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Mr. | 1/17/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Mahbub | [NAME] | 1/17/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Erdem | 1/18/2014 | $1,585.00 | 1 | 3/26/2021
Waid | [NAME] | 1/18/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Ryder | Karan | 1/18/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Meredith | 1/18/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Mostafiz | 1/18/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Candy | 1/19/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Andaleeb | 1/19/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Ashraf | Amit | 1/19/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Ameen | Fahad | 1/19/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Mert | 1/20/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Gianfranco | 1/20/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Arkut | [NAME] | 1/20/2014 | $1,680.00 | 1 | 1/31/2021
[NAME] | [NAME] | 1/21/2014 | $1,530.00 | 1 | 1/28/2021
[NAME] | Office | 1/21/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Summer | Verena | 1/22/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Burney | Humera | 1/22/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Chowdhury | [NAME] | 1/22/2014 | $1,725.00 | 2 | 7/24/2021
Chowdhury | Tanvir | 1/23/2014 | $7,960.00 | 2 | 12/30/2020
[NAME] | Naima | 1/23/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Samanzar | 1/23/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Islam | Fayaad | 1/23/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Hussain | [NAME] | 1/24/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Maya | 1/25/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Ispahani | Emaad | 1/25/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Blondel | [NAME] | 1/25/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Raisa | Adiba | 1/25/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Derek | 1/25/2014 | $0.00 | 0 | 1900-01-01 00:00:00
S | Faruque | 1/26/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Sidiqui | [NAME] | 1/26/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Tilley | Becca | 1/26/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | [NAME] | 1/27/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Murmu | [NAME] | 1/27/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Karim | [NAME] | 1/27/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Faruk | 1/27/2014 | $930.00 | 1 | 7/20/2021
[NAME] | [NAME] | 1/27/2014 | $2,567.50 | 2 | 2021-06-08 00:00:00
Gutierneg | [NAME] | 1/27/2014 | $0.00 | 0 | 1900-01-01 00:00:00
De | [NAME] | 1/28/2014 | $0.00 | 0 | 1900-01-01 00:00:00
TEST | PR | 1/28/2014 | $700.00 | 3 | 2021-12-01 00:00:00
Leadley | Gemma | 1/28/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Chowdhury | [NAME] | 1/28/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Sara | 1/28/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Ferri | Matteo | 1/28/2014 | $2,142.50 | 35 | 2021-08-09 00:00:00
[NAME] | Monty | 1/29/2014 | $910.00 | 1 | 2021-03-03 00:00:00
Bates | [NAME] | 1/29/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Kuddus | Maliha | 1/29/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Reinhard | [NAME] | 1/29/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Dauvet | Remi | 1/30/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Hosaf | Erman | 1/30/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Sir | Samual | 1/30/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Ruffle | [NAME] | 1/30/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Sajid | Nissim | 1/30/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Singer | Mathew | 1/30/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Occhiello | [NAME] | 1/31/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Kamal | [NAME] | 1/31/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Dasgupta | Ronobir | 1/31/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Mahfuz | Akif | 1/31/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Amelie | 1/31/2014 | $0.00 | 0 | 1900-01-01 00:00:00
Khalili | Luba | 1/31/2014 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Rabab | 1/31/2014 | $4,170.00 | 5 | 2021-03-06 00:00:00
Sajjab | Nabila | 2014-01-02 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
Driemeyer | Sima | 2014-01-02 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
Mosh | Faheem | 2014-01-02 00:00:00 | $4,642.50 | 2 | 2021-10-04 00:00:00
[NAME] | Sadia | 2014-01-02 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Rahed | 2014-01-02 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
Singer | Sandra | 2014-01-02 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
Chowdhury | Fareeha | 2014-01-02 00:00:00 | $2,287.50 | 2 | 6/23/2021
Haroon | [NAME] | 2014-01-02 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
Huda | Shamsul | 2014-01-02 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
Hossain | Sharek | 2014-01-02 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00
[NAME] | Zohaib | 2014-01-02 00:00:00 | $0.00 | 0 | 1900-01-01 00:00:00