counting duplicates

[microchippy]

<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

 

[Matty]

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]

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
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	QTY.	Length	Width	Thckns	ID	Machining Req	Part Desc.	Material		Sum of QTY.
2	1	660	15	15	21		tray division wall battens	tulipwood		Length	Width	Thckns	Total
3	1	660	15	15	24		tray division wall battens	tulipwood		482	40	24	2
4	1	660	15	15	29		tray division wall battens	tulipwood		660	15	15	4
5	1	660	15	15	52		tray division wall battens	tulipwood		696	30	24	1
6	1	700	60	18	6	one groove on one face	drawer unit front frame	tulipwood		700	60	18	2
7	1	700	60	18	31	one groove on one face	drawer unit front frame	tulipwood		780	60	18	2
8	1	780	60	18	5	one groove on one face	drawer unit front frame	tulipwood
9	1	780	60	18	32	one groove on one face	drawer unit front frame	tulipwood
10	1	696	30	24	27		drawer unit packers	tulipwood
11	1	482	40	24	2		shelf wall battens	tulipwood
12	1	482	40	24	10
13
Pivot Table

 

[microchippy]

hi peter, this is exactly what i`m looking for . please forgive my stupidty but how do you create a pivot table?

 

[SteveO59L]

Data, Pivot Table and follow the wizard

 

[brettdj]

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]

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

 

[microchippy]

thankyou everyone for your help. i will go and do some research on pivot tables . " i may be gone some time "