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
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