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?
I'm hoping you can help me with a formula. Is it possible to copy the data of the 2nd column into the 3rd column from the immediately preceding row that contains a unique number in the 1st column using only one formula?
Yes, it is possible. Can you provide me with an example set of data that you are working with?