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

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

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
46,165
Office Version
  1. 365
Platform
  1. 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
46,165
Office Version
  1. 365
Platform
  1. 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 "
 

Watch MrExcel Video

Forum statistics

Threads
1,108,719
Messages
5,524,457
Members
409,581
Latest member
khin

This Week's Hot Topics

Top