Add Description for given dates

[jeck876]

I have two columns of Data.

The First Column is Dates and the second one is amounts.

At some point in the first column the dates will start over. (Not always on the first day of the month)

I need to add a description to each transaction. I need the description to be what ever is in Cell A1 until when the dates start over.
I need them to change to what ever is in B1.

For this example I have Withdrawal and Deposit.

In the sheet attached is an example

Everything to the left of the yellow line is my desired outcome.

Thanks!!!!

[JeteMc]

Assuming that the dates on the left side of the yellow line are the actual dates, the following formula gives the results for which you were asking:

=IF(C2<C1,A$2,IF(B1="",A$1,B1))

Here is your file with the formula incorporated on the left side:

Copy of Example Book 6.xlsx

Let me know if there are any questions.

[jeck876]

this is exactly what i am looking for except...is there anyway to do it while having my data in the first row??

i should have added this point earlier...i want the same thing to happen but all my data to just be shifted up one row, to row A

thanks

[JeteMc]

I tried to wrap the formula in an IFERROR(...,A$1) to account for starting on the first row, but could not get it to work. You could certainly just type in "Withdrawal" or use the formula

=A1

for that one description cell.

[JeteMc]

Will the description of the first transaction always be a withdrawal?

[jeck876]

yes, it will always be a withdrawal

[FDibbins]

So, you dont have any headings for this?