Uploaded October 2017 | Updated September 2026, 2 hours ago

---

This concept could save you a lot of time!
Get Excel file here: http://1drv.ms/1bYwrTa
00:00 3 sloppy datasets
01:10 Should we always normalize data?
02:29 Formulas with sliding ranges!?!?
03:34 Sliding range solution 1
05:26 Sliding range solution 2
06:20 Sliding range solution 3