return blank value if it is the last unique value in a column

I'm working on an all encompassing, fully automated budget spanning multiple workbooks. My question involves a very specific portion of this though. I have a list of dated transactions all in order, and one of my helper columns converts the date to the month's text. =TEXT(A1,"mmm") For one of my formulas, I need to make sure the current partial month isn't included. The easiest way would seem to be to have this helper column be blank if it's the last value listed. For example, imagine the following list in columns A & B. How would you make it so March doesn't show up until you enter a non-March date below it in Column A?

1/1/2015 Jan
1/10/2015 Jan
1/15/2015 Jan
1/20/2015 Jan
1/25/2015 Jan
2/1/2015 Feb
2/5/2015 Feb
2/20/2015 Feb
2/25/2015 Feb
2/28/2015 Feb
3/1/2015 Mar
3/3/2015 Mar
3/10/2015 Mar
3/20/2015 Mar

Thanks in advance!

I should add that it's perfectly fine if I need another helper column for this.

I'm hoping there would be a way without going off of the current date. The transactions are downloaded and entered in batches with some buffer time. So even if it's April when I'm looking at it, March may still be incomplete data-wise.

Thanks Moo!! Tested, working, and now I'm out of the house with nothing on my mind!

Whoops, sorry Moo. I gave you some false credit. I was in such a hurry to leave that I didn't fully check it out. It removed a lot more than just March 2015. All is well though. As soon as I typed "now I just need to not include March 2015 on the spending side until a transaction greater than or equal to 4/1/2015 is entered," I knew what I needed to do.

Formula:

Please Login or Register  to view this content.