Learn how to build a dynamic list filtered by criteria in Excel with sub-arrays using INDEX and SMALL. Step-by-step instructions and download-able example.
February 23, 2015 at 8:23 am Thanks. that really helped. I had a similar problem with multiple criteria. I got round it by adding a column to the table using IF, AND & OR statements to give me 1 or 0. I then used that column for my filter (IF) part of the array formula (...
2.4. SCFA Analysis Fermentation supernatant (FS) samples were homogenized in three volumes of internal standard solution (heptanoic acid, 1.68 mmol/L) (Sigma-Aldrich) and centrifuged at 3000× g for 10 min. The supernatant was then distilled and 0.3 µL was injected into a gas chromatograph ...