Resetting a counter based on cell value

[Gregg Wolin]

Happy holidays everyone!
I have a table of data which includes a column that creates a unique, hierarchical ID for each row based on the contents of 2 other rows. I almost got it to work but the counter needs to reset based on the value of other columns in the same row.

The Parcel# formula is =A2+((COUNT(B2:B$2)/100)+B2)/10

A Area B Phase C Parcel# >>> 1 1 1.101 1 1 1.102 1 1 1.103 1 2 1.204 >>>> 1 2 1.205 1 2 1.206 1 3 1.307 >>>> 1 3 1.308 1 3 1.309 1 3 1.310 2 1 2.111 >>> 2 1 2.112 2 2 2.213 >>> 2 2 2.214

Desired 1.101 1.102 1.103 1.201 1.202 1.203 1.301 1.302 1.303 1.304 2.101 2.102 2.201 2.202

 

[Hany ali]

Please Upload The File !!!!

 

[Gregg Wolin]

Please Upload The File !!!!

 

[bosco_yip]

E2, copied down :

=A2+TEXT(COUNTIFS(A$2:A2,A2,B$2:B2,B2),B2&"00")/1000

Regards

 

[p45cal]

test in cell C2:
=IF(B2=B1,C1+0.001,VALUE(A2&"."&B2)+0.001)
copied down.

edit: bosco_yip's is better because the data in columns A and B don't need to be in order.

 

[Gregg Wolin]

E2, copied down :

=A2+TEXT(COUNTIFS(A$2:A2,A2,B$2:B2,B2),B2&"00")/1000

Regards

Thanks!!