如果它们是相同的，则递增单元格中的值

this may be a little difficult for me to explain. I have 1 column in excel that has duplicate entries i.e. more than one red and more than one blue. I need to compare this column against itself and increment each cell with the same word by 1. this may be a little difficult for me to explai