Counting Number of Number with Automaically

[muhammad susanto]

hi all.

how to counting number of number with automatically....

[TABLE="class: tableizer-table"]
<tbody>[TR="class: tableizer-firstrow"]
[TH][/TH]
[TH]data[/TH]
[TH]after formula[/TH]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]1 of 5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]a[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]a[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]a[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]a[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]a[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]a[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]a[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]c[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]c[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]d[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]d[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]d[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]d[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]d[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]d[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]d[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]d[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]d[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]etc...[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[COLOR=#333333]=CEILING(COUNTIF(E$2:E2,E2)/[/COLOR][COLOR=#ff0000]5[/COLOR][COLOR=#333333],1)&" of [/COLOR][COLOR=#ff0000]5[/COLOR][COLOR=#333333]"[/COLOR]

number 5 is manually (given)...how to make automatically..

thanks in advance..

m.susanto

 

[mrshl9898]

Why is it 5?

 

[mrshl9898]

Is this what you were after?

=COUNTIF($E$2:E2,E2)&" of "&COUNTIF(E:E,E2)

 

[muhammad susanto]

yes...you are great!.. thanks