Hi All,
Looking for a solution for the below:
New Column with either R or S. If Transaction for X, are less than 4 on 11/12/20 than all columns are "R", If more than four transaction on 11/12/20, use "R" on that transaction, all others use "S".
Can anyone help with this formula? I currently can only get the <=4 based on date.
IF(COUNTIFS(B:B,B3,C:C,C3)<=4,"R",0))
Looking for a solution for the below:
New Column with either R or S. If Transaction for X, are less than 4 on 11/12/20 than all columns are "R", If more than four transaction on 11/12/20, use "R" on that transaction, all others use "S".
Can anyone help with this formula? I currently can only get the <=4 based on date.
IF(COUNTIFS(B:B,B3,C:C,C3)<=4,"R",0))
X/Y | Date | Time | Kinds | Ticket | Net Sales | Time zone | Type | Price |
X | 11/12/2020 | 12:35 | Adult | 5 | 250 | 12 | 50 | |
X | 11/12/2020 | 12:35 | Others | 2 | 50 | 12 | 25 | |
X | 11/12/2020 | 21:30 | Adult | 10 | 750 | 21 | 75 | |
X | 11/12/2020 | 10:45 | Adult | 2 | 100 | 10 | 50 | |
X | 11/12/2020 | 12:40 | Adult | 5 | 250 | 12 | 50 | |
X | 11/12/2020 | 12:40 | Others | 7 | 175 | 12 | 25 | |
Y | 11/12/2020 | 22:15 | Adult | 4 | 300 | 22 | 75 | |
Y | 11/12/2020 | 22:15 | Others | 3 | 150 | 22 | 50 | |
Y | 11/12/2020 | 22:15 | Adult | 4 | 300 | 22 | 75 |