Spreadsheet: 748482d1632162778-creating-customer-segments-using-ms-excel-creating-customer-segments-using-ms-excel-data-appended-
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
Chowdhury | Azizur | 2014-02-01 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Ruffle | Michelle | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Qadir | Kamal | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Khandker | Daniah | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Sobhan | [NAME] | 2014-02-02 00:00:00 | 5522.5 | 4 | 2021-05-29 00:00:00
Reza | Nafees | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Mehrab | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | [NAME] | 2014-02-02 00:00:00 | 2330 | 1 | 2021-02-08 00:00:00
Miraly | Ambreen | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Shahriar | Saquib | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | [NAME] | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Bosco | [NAME] | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Mohamed | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Hossain | Maneeza | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Chowdhury | Warid | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Adib | 2014-02-02 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Moyeen | [NAME] | 2014-02-02 00:00:00 | 1717.5 | 1 | 2021-06-26 00:00:00
DeNeef | [NAME] | 2014-02-02 00:00:00 | 5050 | 2 | 2020-12-02 00:00:00
Kayes | Kazria | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Farenholtz | Philipp | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Green | Lauren | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Reed | [NAME] | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Sazzad | Shafique | 2014-02-03 00:00:00 | 3200 | 1 | 2020-11-23 00:00:00
[NAME] | Egle | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Siddiqui | [NAME] | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | [NAME] | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Zafar | Anushka | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Doherty | [NAME] | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Kareem | Seema | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Hussain | [NAME] | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Fawaz | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Klokkerhaug | Arild | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Illmer | Alexandra | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Leterme | Gladys | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Muid | Muntasir | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Ayesha | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Haroon | Nahyan | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Chowdhury | [NAME] | 2014-02-03 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Zakir | Mrs | 2014-02-04 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Shakil | 2014-02-04 00:00:00 | 6021.25 | 2 | 2021-05-05 00:00:00
Karim | Shahed | 2014-02-04 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Ahmed | Eram | 2014-02-04 00:00:00 | 5900 | 2 | 2021-02-26 00:00:00
Karim | Azra | 2014-02-04 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Rahim | Farhana | 2014-02-04 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Shazly | 2014-02-04 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Ziad | 2014-02-04 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Mir | [NAME] | 2014-02-04 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Seilman | [NAME] | 2014-02-04 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Laurent | [NAME] | 2014-02-04 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Chauhan | Krish | 2014-02-04 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
ITACA BUDGET LINE | PR | 2014-02-05 00:00:00 | 1790 | 27 | 2021-08-31 00:00:00
[NAME] | [NAME] | 2014-02-05 00:00:00 | 6445 | 3 | 2021-07-05 00:00:00
Yasmin | Tahera | 2014-02-05 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Oliveira | Thais | 2014-02-05 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Tyler | 2014-02-05 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Haque | Joy | 2014-02-05 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Mundy | Mr. | 2014-02-05 00:00:00 | 24980.52 | 9 | 2021-02-24 00:00:00
Majumdar | Rozana | 2014-02-05 00:00:00 | 2750 | 1 | 2021-07-17 00:00:00
Morshed | Lamia | 2014-02-06 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Mangus | [NAME] | 2014-02-06 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Delneuville | Luc | 2014-02-06 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | [NAME] | 2014-02-06 00:00:00 | 4350 | 3 | 2021-04-22 00:00:00
[NAME] | Luc | 2014-02-06 00:00:00 | 13795 | 7 | 2021-06-03 00:00:00
Hawkins | [NAME] | 2014-02-06 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Thorpe | Anne | 2014-02-06 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Yoho | Kristina | 2014-02-06 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Sakerina | 2014-02-06 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Sattar | Sara | 2014-02-06 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Emran | 2014-02-06 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Moyeen | Asad | 2014-02-06 00:00:00 | 1275 | 1 | 2020-11-12 00:00:00
[NAME] | [NAME] | 2014-02-06 00:00:00 | 15065 | 8 | 2021-07-04 00:00:00
Moore | Sean | 2014-02-07 00:00:00 | 8092.5 | 6 | 2021-05-05 00:00:00
[NAME] | Zahin | 2014-02-07 00:00:00 | 7262.5 | 2 | 2021-06-20 00:00:00
Henriod | Michel | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Almer | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Rizvi | [NAME] | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Saleh | Amyn | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Raub | [NAME] | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Govinda | [NAME] | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | [NAME] | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Love | [NAME] | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
D'Urso | [NAME] | 2014-02-07 00:00:00 | 1725 | 1 | 2021-03-15 00:00:00
Yousuf | [NAME] | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Ispahani | [NAME] | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Pokatera | Sid | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Karim | Mishal | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Azad | Sakib | 2014-02-07 00:00:00 | 1880 | 2 | 2021-02-27 00:00:00
Syed | Jan | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Risvi | Zaki | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Kamal | Erum | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Narayan | [NAME] | 2014-02-07 00:00:00 | 1035 | 1 | 2021-03-11 00:00:00
[NAME] | Sazia | 2014-02-07 00:00:00 | 11517.5 | 7 | 2021-06-18 00:00:00
Mckenna | [NAME] | 2014-02-07 00:00:00 | 952.5 | 1 | 2021-04-09 00:00:00
Ahmed | Mushroof | 2014-02-07 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
[NAME] | Ashwani | 2014-02-08 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Delquie | Nalisa | 2014-02-08 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Hoeksema | [NAME] | 2014-02-08 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Haque | [NAME] | 2014-02-08 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Sieghare | [NAME] | 2014-02-08 00:00:00 | 0 | 0 | 1900-01-01 00:00:00
Bang | Woohyuk | 2014-02-08 00:00:00 | 0 | 0 | 1900-01-01 00:00:00