Counter for Unique Numbers in ascending order

[awagdarikar]

Hi Excel Experts,

I have got entries for Order Number in one column and I want to create a counter for each Unique Order Number in the cell next to it. I want the counter to show the occurrence in the way they repeat (1-2-3-4 that is in ascending order). I have used “COUNTIF” function as shown below. However the result I got is not correct see counter values for Order Number 9915. I need results as shown in “Required Result” column. The solution should also be able to count multiple occurrences for every unique value within the range (due to mailing constraints above data has only one Order Number which is repeating).

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<TABLE class=MsoNormalTable style="WIDTH: 470.5pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0in 5.4pt 0in 5.4pt" cellSpacing=0 cellPadding=0 width=627 border=0><TBODY><TR style="HEIGHT: 15pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes" height=20><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=84 height=20>

Column A<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=129 height=20>

Column B<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=195 height=20>

Column C<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=90 height=20>

Column D<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=129 height=20>

Column E<o></o>​

</TD></TR><TR style="HEIGHT: 30.75pt; mso-yfti-irow: 1; mso-height-source: userset" height=41><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 30.75pt; BACKGROUND-COLOR: transparent" vAlign=top width=84 height=41>

(Row
Number)<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 30.75pt; BACKGROUND-COLOR: transparent" vAlign=top width=129 height=41>

<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_m1026 u2:spt="201" coordsize="21600,21600" o:spt="1" path="m,l,21600r21600,l21600,xe"><v:stroke joinstyle="miter"></v:stroke><vath gradientshapeok="f" u2:connecttype="rect" u2:extrusionok="f" shadowok="f" strokeok="f" fillok="f" o:connecttype="segments"></vath></v:shapetype><v:shape id=_x0000_s1027 style="MARGIN-TOP: 0px; Z-INDEX: 2; LEFT: 0px; VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 223.5pt; POSITION: absolute; HEIGHT: 15pt; TEXT-ALIGN: left; mso-position-horizontal-relative: text; mso-position-vertical-relative: text" o:spt="1" path="m,l,21600r21600,l21600,xe" type="#_x0000_m1026" stroked="f"><v:stroke joinstyle="miter"></v:stroke><vath gradientshapeok="f" shadowok="f" strokeok="f" fillok="f" o:connecttype="segments"></vath></v:shape><v:shape id=_x0000_s1028 style="MARGIN-TOP: 0px; Z-INDEX: 3; LEFT: 0px; VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 223.5pt; POSITION: absolute; HEIGHT: 15pt; TEXT-ALIGN: left; mso-position-horizontal-relative: text; mso-position-vertical-relative: text" o:spt="1" path="m,l,21600r21600,l21600,xe" type="#_x0000_m1026" stroked="f"><v:stroke joinstyle="miter"></v:stroke><vath gradientshapeok="f" shadowok="f" strokeok="f" fillok="f" o:connecttype="segments"></vath></v:shape><v:shape id=_x0000_s1029 style="MARGIN-TOP: 0px; Z-INDEX: 4; LEFT: 0px; VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 223.5pt; POSITION: absolute; HEIGHT: 15pt; TEXT-ALIGN: left; mso-position-horizontal-relative: text; mso-position-vertical-relative: text" o:spt="1" path="m,l,21600r21600,l21600,xe" type="#_x0000_m1026" stroked="f"><v:stroke joinstyle="miter"></v:stroke><vath gradientshapeok="f" shadowok="f" strokeok="f" fillok="f" o:connecttype="segments"></vath></v:shape><v:shape id=_x0000_s1030 style="MARGIN-TOP: 0px; Z-INDEX: 5; LEFT: 0px; VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 223.5pt; POSITION: absolute; HEIGHT: 15pt; TEXT-ALIGN: left; mso-position-horizontal-relative: text; mso-position-vertical-relative: text" o:spt="1" path="m,l,21600r21600,l21600,xe" type="#_x0000_m1026" stroked="f"><v:stroke joinstyle="miter"></v:stroke><vath gradientshapeok="f" shadowok="f" strokeok="f" fillok="f" o:connecttype="segments"></vath></v:shape><v:shape id=_x0000_s1031 style="MARGIN-TOP: 0px; Z-INDEX: 6; LEFT: 0px; VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 223.5pt; POSITION: absolute; HEIGHT: 15pt; TEXT-ALIGN: left; mso-position-horizontal-relative: text; mso-position-vertical-relative: text" o:spt="1" path="m,l,21600r21600,l21600,xe" type="#_x0000_m1026" stroked="f"><v:stroke joinstyle="miter"></v:stroke><vath gradientshapeok="f" shadowok="f" strokeok="f" fillok="f" o:connecttype="segments"></vath></v:shape>Order No.<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 30.75pt; BACKGROUND-COLOR: transparent" vAlign=top width=195 height=41 x:str="Formula ">

Formula<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 30.75pt; BACKGROUND-COLOR: transparent" vAlign=top width=90 height=41>

Formula Result<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 30.75pt; BACKGROUND-COLOR: transparent" vAlign=top width=129 height=41>

Required Result<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 2" height=20><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=84 height=20 x:num>

3<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=129 bgColor=silver height=20 x:num>

9915<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=195 bgColor=silver height=20 x:num="0" x:fmla="=COUNTIF(B$5:B5,B4)">

=COUNTIF(B$5:B5,B4)<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=90 bgColor=silver height=20 x:num>

0<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=129 bgColor=silver height=20 x:num>

1<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 3" height=20><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=84 height=20 x:num>

4<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

9916<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=195 bgColor=silver height=20 x:num="1" x:fmla="=COUNTIF(B$5:B6,B5)">

=COUNTIF(B$5:B6,B5)<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=90 height=20 x:num>

1<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

0<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 4" height=20><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=84 height=20 x:num>

5<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=129 bgColor=silver height=20 x:num>

9915<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=195 bgColor=silver height=20 x:num="1" x:fmla="=COUNTIF(B$5:B7,B6)">

=COUNTIF(B$5:B7,B6)<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=90 bgColor=silver height=20 x:num>

1<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=129 bgColor=silver height=20 x:num>

2<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 5" height=20><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=84 height=20 x:num>

6<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

9918<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=195 bgColor=silver height=20 x:num="3" x:fmla="=COUNTIF(B$5:B8,B7)">

=COUNTIF(B$5:B8,B7)<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=90 height=20 x:num>

3<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

0<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 6" height=20><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=84 height=20 x:num>

7<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=129 bgColor=silver height=20 x:num>

9915<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=195 bgColor=silver height=20 x:num="3" x:fmla="=COUNTIF(B$5:B9,B8)">

=COUNTIF(B$5:B9,B8)<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=90 bgColor=silver height=20 x:num>

3<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=129 bgColor=silver height=20 x:num>

3<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 7" height=20><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=84 height=20 x:num>

8<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=129 bgColor=silver height=20 x:num>

9915<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=195 bgColor=silver height=20 x:num="1" x:fmla="=COUNTIF(B$5:B10,B9)">

=COUNTIF(B$5:B10,B9)<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=90 bgColor=silver height=20 x:num>

1<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=129 bgColor=silver height=20 x:num>

4<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 8" height=20><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=84 height=20 x:num>

9<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

9921<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=195 bgColor=silver height=20 x:num="1" x:fmla="=COUNTIF(B$5:B11,B10)">

=COUNTIF(B$5:B11,B10)<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=90 height=20 x:num>

1<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

0<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 9" height=20><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=84 height=20 x:num>

10<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

9922<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=195 bgColor=silver height=20 x:num="1" x:fmla="=COUNTIF(B$5:B12,B11)">

=COUNTIF(B$5:B12,B11)<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=90 height=20 x:num>

1<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

0<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 10" height=20><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=84 height=20 x:num>

11<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

9923<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=195 bgColor=silver height=20 x:num="1">

=COUNTIF(B$5:B13,B12)<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=90 height=20 x:num>

1<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

0<o></o>​

</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 11; mso-yfti-lastrow: yes" height=20><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 62.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=84 height=20 x:num>

12<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

9924<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 146.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt" vAlign=bottom width=195 bgColor=silver height=20 x:num="0">

=COUNTIF(B$5:B14,B13)<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 67.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=90 height=20 x:num>

0<o></o>​

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 96.8pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=bottom width=129 height=20 x:num>

0<o></o>​

</TD></TR></TBODY></TABLE>


Please help me achieve required results.
Regards,
awagdarikar<o></o>
<o> </o>

 

[chrisl]

If you put =COUNTIF(B$3:B3,B3) in cell E3 and copy down it should work. This will give a unique counter for all record numbers.

 

[awagdarikar]

Thanks mate!

Fantastic way to apply countif. Your answer works perfectly.

You are a legend!!!!!!!

Thanks again,

awagdarikar