July 11, 2017
I can not work out why the formula is giving an error?
Any help greatly appreciated
December 20, 2019
July 16, 2010
You need to unpivot the data so it's in a tabular format to work with these functions. They are not designed to work with non-continuous columns.