Please help with a formula!
I am looking to compare Year to Date numbers, and I'm having a hard time figuring out a formula to do so. I've attached a sample screen shot. At the end of the day, I'm trying to add a metric into a dashboard that shows 2018 vs 2019 year to date. I created the "YTD" column that shows the value of the last column that has data in it on the right side of the row, which works great for the current year. But for 2018, I need to somehow calculate tell it to "Look at the last row with data (other than YTD) and deliver the number above that". Does that make sense? Any way I can do that? I know it looks like I could easily type it in once per quarter, but I'm using this as an example. We are actually doing weekly tracking.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!