Formula to Return Last Cell With Data in a Series of Columns

Hi! I am looking for a formula that I thought would be simple, but I cannot find anything online that matches what I need.

I have a spreadsheet that has money data in columns B through E (ex. headers are: B=2016 Gift, C=2017 Gift, D= 2018 Gift, E=2019 Gift). I need a formula that I can put in column F, that will tell me what the last gift was (ex. looks through all columns and returns the most recent gift). So whether that gift was in 2016 or 2019, or they gave a gift for every year in between, I only want to see their most recent gift as the result of my formula in Column F.

I know I could do it manually by sorting and pasting for each year, but I have tens of thousands of rows and I need to do this often, so I'm hoping to find a formula that will do the trick.

Any ideas?

Thanks in advance!
Spacle

Sample attached with desired formula result in column F.

Thanks!

array formula
F2 =

Formula:

Please Login or Register  to view this content.

then fill down

That worked great! Thanks very much, ThxAlot!