counting duplicates

microchippy

New Member
Joined
Jul 19, 2010
Messages
3
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 91px"><COL style="WIDTH: 151px"><COL style="WIDTH: 121px"><COL style="WIDTH: 121px"><COL style="WIDTH: 41px"><COL style="WIDTH: 319px"><COL style="WIDTH: 307px"><COL style="WIDTH: 131px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">A</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">B</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">C</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">D</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">E</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">F</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">G</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">H</TD></TR><TR style="HEIGHT: 91px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">QTY.</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">Length</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">Width</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">Thckns</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">ID</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">Machining Req</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">Part Desc.</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">Material</TD></TR><TR style="HEIGHT: 27px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">660</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">15</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">21</TD><TD style="FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tray division wall battens</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tulipwood</TD></TR><TR style="HEIGHT: 55px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">3</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">660</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">15</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">24</TD><TD style="FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tray division wall battens</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tulipwood</TD></TR><TR style="HEIGHT: 27px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">660</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">15</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">29</TD><TD style="FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tray division wall battens</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tulipwood</TD></TR><TR style="HEIGHT: 27px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">5</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">660</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">15</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">52</TD><TD style="FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tray division wall battens</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tulipwood</TD></TR><TR style="HEIGHT: 55px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">6</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">700</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">60</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">18</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">one groove on one face</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">drawer unit front frame</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tulipwood</TD></TR><TR style="HEIGHT: 55px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">7</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">700</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">60</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">18</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">31</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">one groove on one face</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">drawer unit front frame</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tulipwood</TD></TR><TR style="HEIGHT: 55px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">8</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">780</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">60</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">18</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">one groove on one face</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">drawer unit front frame</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tulipwood</TD></TR><TR style="HEIGHT: 55px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">9</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">780</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">60</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">18</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">32</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">one groove on one face</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">drawer unit front frame</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tulipwood</TD></TR><TR style="HEIGHT: 55px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">10</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">696</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">30</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">24</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">27</TD><TD style="FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">drawer unit packers</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tulipwood</TD></TR><TR style="HEIGHT: 55px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">11</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">482</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">40</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">24</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">2</TD><TD style="FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">shelf wall battens</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tulipwood</TD></TR><TR style="HEIGHT: 55px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">12</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">482</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">40</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">24</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">10</TD><TD style="FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">shelf wall battens</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Century Gothic; FONT-SIZE: 18pt; FONT-WEIGHT: bold">tulipwood</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

hi above is an example of a timber cutting list. What i need help is a formula or macro that with look for dupilcates and display the total in another column
e.g <TABLE style="WIDTH: 363pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=484><COLGROUP><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3328" width=91><COL style="WIDTH: 113pt; mso-width-source: userset; mso-width-alt: 5522" width=151><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" span=2 width=121><TBODY><TR style="HEIGHT: 22.5pt" height=30><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 68pt; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=30 width=91>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 113pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=151>660</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 91pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=121>15</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 91pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=121>15</TD></TR><TR style="HEIGHT: 45pt; mso-height-source: userset" height=60><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 68pt; HEIGHT: 45pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=60 width=91>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 113pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=151>660</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 91pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=121>15</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 91pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=121>15</TD></TR><TR style="HEIGHT: 22.5pt" height=30><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 68pt; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=30 width=91>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 113pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=151>660</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 91pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=121>15</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 91pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=121>15</TD></TR><TR style="HEIGHT: 22.5pt" height=30><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 68pt; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=30 width=91>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 113pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=151>660</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 91pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=121>15</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 91pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=121>15</TD></TR></TBODY></TABLE>

column to show some thing like this

there are 4 number of 660 15 15

please any reply in plain english as i am `thick as two short planks` when it come to excel.

thanks
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Matty

Well-known Member
Joined
Feb 17, 2007
Messages
3,710
Re: counting dupilcates

Welcome to the Board...

Let's assume the first table you posted resides in range A1:H12. Now, given that the unique 'cuts' are as follows:

<TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=192><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 height=17 width=64>Length</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=64>Width</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=64>Thckns</TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: yellow; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl65 height=17 width=64>660</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=64>15</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=64>15</TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 height=17 width=64>700</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=64>60</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=64>18</TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 height=17 width=64>780</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=64>60</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=64>18</TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 height=17 width=64>696</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=64>30</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=64>24</TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: yellow; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl65 height=17 width=64>482</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=64>40</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=64>24</TD></TR></TBODY></TABLE>

Where the above table resides in range A14:C19, try the following in D15:

=SUM(IF(B$2:B$12=A15,IF(C$2:C$12=B15,IF(D$2:D$12=C15,1))))

Which requires committing with Ctrl+Shift+Enter and can then be copied down.

Is this what you wanted?

Matty
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
45,918
Office Version
365
Platform
Windows
Re: counting dupilcates

Welcome to the MrExcel board!

Could you just use Excel's built-in Pivot Table feature? I've used that to create the table in columns J:M below. Is that the sort of result you area after?

Excel Workbook
ABCDEFGHIJKLMN
1QTY.LengthWidthThcknsIDMachining ReqPart Desc.MaterialSum of QTY.
21660151521tray division wall battenstulipwoodLengthWidthThcknsTotal
31660151524tray division wall battenstulipwood48240242
41660151529tray division wall battenstulipwood66015154
51660151552tray division wall battenstulipwood69630241
6170060186one groove on one facedrawer unit front frametulipwood70060182
71700601831one groove on one facedrawer unit front frametulipwood78060182
8178060185one groove on one facedrawer unit front frametulipwood
91780601832one groove on one facedrawer unit front frametulipwood
101696302427drawer unit packerstulipwood
11148240242shelf wall battenstulipwood
121482402410
13
Pivot Table
 

microchippy

New Member
Joined
Jul 19, 2010
Messages
3
hi peter, this is exactly what i`m looking for . please forgive my stupidty but how do you create a pivot table?
 

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896

ADVERTISEMENT

Data, Pivot Table and follow the wizard
 

brettdj

Active Member
Joined
Feb 5, 2003
Messages
426
If you wanted just the duplicates, flexibility on handling the strings (say deleting extra white spaces), or more control over the data (say deleting the duplicate rows, highlighting etc) then you could use my duplicate master addin available at http://www.experts-exchange.com/A_2123.html

- Search Option: run the row functionality
- Application Scope: range as columns B:D

Cheers

Dave
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
45,918
Office Version
365
Platform
Windows
hi peter, this is exactly what i`m looking for . please forgive my stupidty but how do you create a pivot table?
Depends which version of Excel you have. Starting point is the built-in Help and try searching for 'Create Pivot Table'. Give it a try, but if you need more detailed instructions, post back with your Excel version.

You may also want to have a look under 'P' here
 
Last edited:

microchippy

New Member
Joined
Jul 19, 2010
Messages
3
thankyou everyone for your help. i will go and do some research on pivot tables . " i may be gone some time "
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,442
Messages
5,511,384
Members
408,846
Latest member
terraf

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top