Determine Sequence

[spcalan]

I have a list of Invoices with a Date and Email Addresses from a sales database.

I have counted the number of invoices per email address...but now I need to mark each invoice as "First / Second/Third, Fourth, Fifth Order .. basically what sequence....

I am trying to calculate the number of days on average between a customer's first order and 2nd order...


How do I post a photo ?

 

[spcalan]

Payment Date (MST)	Processed by E-j (MST)	Transaction ID	Payment Processor	E-j Internal Txn ID	Payment Status	First Name	Last Name	Order Sequence	Count	Payer E-mail
12/26/2018	12/26/2018	st-ch_1DlgUyBagK2TtORQOyu6JtFT	Stripe	XXXX	Completed	Mr.	Smith	1	1	AA@AOL.com
3/15/2019	3/15/2019	st-ch_1EEOWpBagK2TtORQ9gNhsIT0	Stripe	XXXX	Completed	Mr.	Smith	1	2	AA1@AOL.com
3/15/2019	3/15/2019	st-ch_1EEOWpBagK2TtORQ9gNhsIT0	Stripe	XXXX	Completed	Mr.	Smith	2	2	AA1@AOL.com
4/12/2019	4/12/2019	st-ch_1EOQgyBagK2TtORQnU9fOuSo	Stripe	XXXX	Completed	Mr.	Smith	1	13	AA2@AOL.com
5/9/2019	5/9/2019	st-ch_1EYByeBagK2TtORQ9CLQ3ojz	Stripe	XXXX	Completed	Mr.	Smith	2	13	AA2@AOL.com
5/23/2019	5/23/2019	st-ch_1EdFD2BagK2TtORQW0RyxKLB	Stripe	XXXX	Completed	Mr.	Smith	3	13	AA2@AOL.com
5/30/2019	5/30/2019	st-ch_1Eg2hdBagK2TtORQUlyskW3p	Stripe	XXXX	Completed	Mr.	Smith	4	13	AA2@AOL.com
5/30/2019	5/30/2019	st-ch_1Eg2lQBagK2TtORQpbl6p851	Stripe	XXXX	Completed	Mr.	Smith	5	13	AA2@AOL.com
6/7/2019	6/7/2019	st-ch_1EimYlBagK2TtORQVyQpaNFv	Stripe	XXXX	Completed	Mr.	Smith	6	13	AA2@AOL.com
6/12/2019	6/12/2019	st-ch_1EkdUXBagK2TtORQOyatoou8	Stripe	XXXX	Completed	Mr.	Smith	7	13	AA2@AOL.com
6/14/2019	6/14/2019	st-ch_1ElLm8BagK2TtORQfsAKqLZ0	Stripe	XXXX	Completed	Mr.	Smith	8	13	AA2@AOL.com
6/17/2019	6/17/2019	st-ch_1EmV6YBagK2TtORQjxY8e5bq	Stripe	XXXX	Completed	Mr.	Smith	9	13	AA2@AOL.com
6/18/2019	6/18/2019	st-ch_1EmkRlBagK2TtORQAJa0JiLp	Stripe	XXXX	Completed	Mr.	Smith	10	13	AA2@AOL.com
6/19/2019	6/19/2019	st-ch_1En8MnBagK2TtORQjcdjQ87u	Stripe	XXXX	Completed	Mr.	Smith	11	13	AA2@AOL.com
6/22/2019	6/22/2019	st-ch_1EoFM2BagK2TtORQypNH049G	Stripe	XXXX	Completed	Mr.	Smith	12	13	AA2@AOL.com
6/22/2019	6/22/2019	st-ch_1EoFPeBagK2TtORQYADvjYgS	Stripe	XXXX	Completed	Mr.	Smith	13	13	AA2@AOL.com

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Fluff]

How about

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Payment Date (MST)	Processed by E-j (MST)	Transaction ID	Payment Processor	E-j Internal Txn ID	Payment Status	First Name	Last Name	Order Sequence	Count	Payer E-mail
2	12/26/2018	12/26/2018	st-ch_1DlgUyBagK2TtORQOyu6JtFT	Stripe	XXXX	Completed	Mr.	Smith	1	1	AA@AOL.com
3	3/15/2019	3/15/2019	st-ch_1EEOWpBagK2TtORQ9gNhsIT0	Stripe	XXXX	Completed	Mr.	Smith	1	2	AA1@AOL.com
4	3/15/2019	3/15/2019	st-ch_1EEOWpBagK2TtORQ9gNhsIT0	Stripe	XXXX	Completed	Mr.	Smith	2	2	AA1@AOL.com
5	04/12/2019	04/12/2019	st-ch_1EOQgyBagK2TtORQnU9fOuSo	Stripe	XXXX	Completed	Mr.	Smith	1	13	AA2@AOL.com
6	05/09/2019	05/09/2019	st-ch_1EYByeBagK2TtORQ9CLQ3ojz	Stripe	XXXX	Completed	Mr.	Smith	2	13	AA2@AOL.com
7	5/23/2019	5/23/2019	st-ch_1EdFD2BagK2TtORQW0RyxKLB	Stripe	XXXX	Completed	Mr.	Smith	3	13	AA2@AOL.com
8	5/30/2019	5/30/2019	st-ch_1Eg2hdBagK2TtORQUlyskW3p	Stripe	XXXX	Completed	Mr.	Smith	4	13	AA2@AOL.com
9	5/30/2019	5/30/2019	st-ch_1Eg2lQBagK2TtORQpbl6p851	Stripe	XXXX	Completed	Mr.	Smith	5	13	AA2@AOL.com
10	06/07/2019	06/07/2019	st-ch_1EimYlBagK2TtORQVyQpaNFv	Stripe	XXXX	Completed	Mr.	Smith	6	13	AA2@AOL.com
11	06/12/2019	06/12/2019	st-ch_1EkdUXBagK2TtORQOyatoou8	Stripe	XXXX	Completed	Mr.	Smith	7	13	AA2@AOL.com
12	6/14/2019	6/14/2019	st-ch_1ElLm8BagK2TtORQfsAKqLZ0	Stripe	XXXX	Completed	Mr.	Smith	8	13	AA2@AOL.com
13	6/17/2019	6/17/2019	st-ch_1EmV6YBagK2TtORQjxY8e5bq	Stripe	XXXX	Completed	Mr.	Smith	9	13	AA2@AOL.com
14	6/18/2019	6/18/2019	st-ch_1EmkRlBagK2TtORQAJa0JiLp	Stripe	XXXX	Completed	Mr.	Smith	10	13	AA2@AOL.com
15	6/19/2019	6/19/2019	st-ch_1En8MnBagK2TtORQjcdjQ87u	Stripe	XXXX	Completed	Mr.	Smith	11	13	AA2@AOL.com
16	6/22/2019	6/22/2019	st-ch_1EoFM2BagK2TtORQypNH049G	Stripe	XXXX	Completed	Mr.	Smith	12	13	AA2@AOL.com
17	6/22/2019	6/22/2019	st-ch_1EoFPeBagK2TtORQYADvjYgS	Stripe	XXXX	Completed	Mr.	Smith	13	13	AA2@AOL.com
Sheet4

Cell Formulas
Range	Formula
I2	=COUNTIF(K$2:K2,K2)