Insert Total row if duplicates exists

[moglione1]

Hi all,

I have the following list
340
341
341
345
346
346
351
511
516
517
519
524
540

I was wondering if there is any way to insert a new TOTAL row if duplicate values exist. I.e. The number 341 appears twice or more

P.s. Pivot tables will not work for what I want to achieve in the long run

[Otto Moehrbach]

I presume you want this TOTAL row to sum the list. What do want to happen
if there are duplicate entries? HTH Otto
"moglione1" <[email protected]> wrote
in message news:[email protected]...
>
> Hi all,
>
> I have the following list
> 340
> 341
> 341
> 345
> 346
> 346
> 351
> 511
> 516
> 517
> 519
> 524
> 540
>
> I was wondering if there is any way to insert a new TOTAL row if
> duplicate values exist. I.e. The number 341 appears twice or more
>
> P.s. Pivot tables will not work for what I want to achieve in the long
> run
>
>
> --
> moglione1
> ------------------------------------------------------------------------
> moglione1's Profile:
> http://www.excelforum.com/member.php...o&userid=26414
> View this thread: http://www.excelforum.com/showthread...hreadid=521154
>