The SCAN function lives in a single cell and spills the results down the column, ensuring my totals are always structurally ...
Abstract: Measurement data sometimes contain a few outliers that have a large deviation from the actual value. For such data, the reconstruction results will be greatly distorted around the outliers.