Assign integer value based on customer email date-CodePudding

Home > Software engineering > Assign integer value based on customer email date

Assign integer value based on customer email date

Time：10-13

Context: I have 2 columns of data: Col 1: date Col 2: customer email address

The same customer orders multiple times on different days

Problem: I want to understand how to assign based on date, and customer email address, whether it's their first time, second time etc.

I have not figure it out and looking for some help :)

Thanks a lot!

Example spreadsheet:

Formula in E2:

=INDEX(IF(B2:B="","",COUNTIFS(C2:C,C2:C,B2:B,"<="&B2:B)))