| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| total duplicates, remove originals, and add to foot of spreadsheet | Excel Discussion (Misc queries) | |||
| Insert Blank Row Below Sub-Total? | Excel Worksheet Functions | |||
| How do I insert a Sub total at every page break? | Excel Discussion (Misc queries) | |||
| count duplicates/total number of occurances | Excel Discussion (Misc queries) | |||
| Insert Grand total at the end | Excel Programming | |||
![moglione1[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
