Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data ... table below shows the different functions you can ...

Using Microsoft Excel In order to compare data collected on two different pods, it's best to subtract baseline data from both measurements. AQ-IQ Mentor Anna Iisa explains how to do this in this video ...