muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all.
how to counting number of number with automatically....
<tbody>
</tbody>
number 5 is manually (given)...how to make automatically..
thanks in advance..
m.susanto
how to counting number of number with automatically....
data | after formula | |
---|---|---|
1 | a | 1 of 5 |
2 | a | |
3 | a | |
4 | a | |
5 | a | |
6 | a | |
7 | a | |
8 | a | |
9 | c | |
10 | c | |
11 | d | |
12 | d | |
13 | d | |
14 | d | |
15 | d | |
16 | d | |
17 | d | |
18 | d | |
19 | d | |
20 | etc... | |
21 | ||
22 | ||
23 |
<tbody>
</tbody>
Code:
[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
Last edited: