The conversation between human and AI assistant.
How can I copy data of 2nd Column in the 3rd column from immediately preceding row that contains unique number in the 1st column using one formula?
Yes, that's correct.
Alright, here's the formula you can use:

`=IF(COUNTIF($A$1:A1,A1)>1,B2,IFERROR(VLOOKUP(A1-1,$A$1:B1,2,FALSE),B2))`

You can enter this formula in cell C1 and drag it down to fill the rest of column C.