Thanks so much William and John. I went straight to John's formula, which works. It also occurred to me that if I want some other metric such as trimean or median, I could rearrange the formula so it begins with an If statement. (=if date in C is... , trimean). If I did that would it reduce CPU time since its not an array?
Bookmarks