Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B14 | B2 | =IF(COUNTIF($B$1:B1,B1)=4,B1+1,B1) |
C2:C14 | C2 | =IF(B1=B2,CHAR( CODE(C1)+1),"A") |
tHANKS A LOT, THAT WORKED=IF(B1=B2,CHAR( CODE(C1)+1),"A")
365, i updated my details to reflectWhat version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)