Hello, I have a column with dates and a column with measurements. The measurements only happen every 14 days. I need an IF statement that will show the current value if there is and increase and shows the previous value if there is a decrease. This would be pretty easy to figure out if there were values in every cell but I cant figure it out with the 14 day gap. I added a column and manually put in the numbers I need to show what I mean. Thanks
Bookmarks