Insert Total row if duplicates exists
 

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

Insert Total row if duplicates exists
 

I presume you want this TOTAL row to sum the list. What do want to happen
if there are duplicate entries? HTH Otto
"moglione1" wrote
in message ...

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