If >=4 transaction based on date, if there are <=4 cell's that "S", use the top values to make cell "R"

[manloonw]

Hi all, sorry the title is abit confusing.

I have the following headings:

Date, Value, R/S, Commission

I am trying to set the formula's the following rules for the R/S column.

1 If there are less than four transactions per day, all R/S cells belonging to the transaction must = R
2 If there are more than four transactions per day, at top four transaction must be = R based on value column.
Example there are 6 transaction dated 18/3/21, two of them are already R and I need the another two cells to change to R based on their highest value

I currently have the formula as If(countif(A:A,A2)<=4,"R","")

Any help would be appreciated

 

[Joe4]

Welcome to the Board!

Put this formula in cell A2 and copy down, and I think it should handle both situations:

=IF(COUNTIF(A$2:A2,A2)<=4,"R","")