Excel count functions

Question

I have a spreadsheet of setters of a crossword and have a COUNTIF function that gives me the number of times each setter has appeared

=COUNTIF(C:C,C2) gives me the sum of all occurrences of that setter

but instead of a sum that is the same for each occurrence I would prefer an ordinal sequence 1 of 194, 2 of 194 etc is there a way I can do this?

oliverscheurich · Answer

JohnBlack1570&nbsp;=COUNTIF($C$2:C2,C2)&amp;" of "&amp;COUNTIF(C:C,C2)&nbsp;You can apply two formulas like this.

johnblack1570 · Answer

Thanks that is just what I was looking forOliverScheurich&nbsp;

Forum Discussion