Cell C1
=IF(COUNTIF($A$1:A1,A1)=1,SUMIF(A:A,A1,B:B),"")
Cell C1
=IF(COUNTIF($A$1:A1,A1)=1,SUMIF(A:A,A1,B:B),"")
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks