>>1379742It's best I clarify some details
For one I can't sort the columns
Secondly there must only be one function, so it then can be copy pasted into the following cells of Column A
Pic related is a screenshot from the actual Excel spreadsheet I am working on - notice how in the bottom of Column B, values start repeating (but their matching value on Colum A must still be equal to their previously assigned values)
Finally this is the best solution I came up with so far (replace the X with row numbers) :
> =IF(BX=B(X-1); A(X-1); IF(BX<>""; A(X-1)+1; ""))The problem with this obviously the fact I can only look into the previous row, as opposed to all previous rows in search of matching Column B values which would be the ideal
