I am trying to return the last input in a date range, for example January the input was on the 31st for an amount of 5, February the last input was on the 26th in the amount of 10 and march the last input was on the 17th in the amount of 23, and this will go on for the rest of the year on random dates.
So I made a column for Jan, Feb, Mar, etc.
So in Jan I want a formula to where it will show 5, Feb it will so 10, and mar it will show 23.
I have tried various types of formulas and can't figure this one out.
So I made a column for Jan, Feb, Mar, etc.
So in Jan I want a formula to where it will show 5, Feb it will so 10, and mar it will show 23.
I have tried various types of formulas and can't figure this one out.