Counting Formula Without Helper Column

[muhammad susanto]

hi all....

how to data counting without helper column
this layout :

Excel 2007

	A	B
data (text)	after formula (counting)
test-a
test-a
test-a
test-a
xx
ffffff
ffffff
w

<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=E0E0F0"" target="_blank"></colgroup><colgroup><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"] 4 [/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]1[/TD]

</tbody>

​

anyone help thank you so much...
m.susanto

 

[BrianJN1]

I regret that I don't understand what you require.
I am assuming that you somehow want to add, by your example, 4 items of the first data, 1 of the second, 2 of the third and 1 of the last through a VBA program but you don't want those counter values to appear.

Can you please explain better what you need?

 

[Eric W]

Put this formula in B2, then copy it down:

=IF(COUNTIF($B$2:$B2,B2)=1,COUNTIF(B:B,B2),"")

 

[muhammad susanto]

Put this formula in B2, then copy it down:

=IF(COUNTIF($B$2:$B2,B2)=1,COUNTIF(B:B,B2),"")

h Eric. thank you so much..
should be =IF(COUNTIF($A$2:$A2,A2)=1,COUNTIF(A:A,A2),"")

 

[Aladin Akyurek]

In B2 enter and copy down:

=IF(ISNA(MATCH(A2,$A$1:A1,0)),COUNTIFS($A$2:$A$9,$A2),"")

which should be a tad faster.