Fill Series Number With Criteria

muhammad susanto

Well-known Member
Joined
Jan 8, 2013
Messages
1,511
helllo...

i am looking formula to fill series number based on adjacent with basic count of data 3 cell like this :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>expected result</th><th>data</th></tr></thead><tbody>
<tr><td>1</td><td>a</td></tr>
<tr><td>1</td><td>a</td></tr>
<tr><td>1</td><td>a</td></tr>
<tr><td>2</td><td>a</td></tr>
<tr><td>2</td><td>a</td></tr>
<tr><td>2</td><td>a</td></tr>
<tr><td>3</td><td>a</td></tr>
<tr><td>4</td><td>e</td></tr>
<tr><td>5</td><td>f</td></tr>
<tr><td>5</td><td>f</td></tr>
<tr><td> </td><td>etc..</td></tr>
</tbody></table>

any help...greatly thanks in advance..

.sst
 

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,055
I had these in columns A and B.


In C2 =IF(B2=B1,0,1)+IF((COUNTIF(B$2:B2,B2)-1)/3=0,0,IF(ROUNDDOWN((COUNTIF(B$2:B2,B2)-1)/3,0)=(COUNTIF(B$2:B2,B2)-1)/3,1,0))
In D2 =SUM(C$2:C2)
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,571
Office Version
2010
Platform
Windows
hey ricks...not working...put a or 1 in cell A2?
Describe "not working"... what happens that shouldn't happen?

Yes, A1 will always be 1, so put it there (the formula needs a number in the preceding cell in order to work)... then put the formula in A3 and copy it down.
 

Forum statistics

Threads
1,085,588
Messages
5,384,615
Members
401,913
Latest member
chethan av

Some videos you may like

This Week's Hot Topics

Top