Google Sheets - Find the lowest values in the entire table line by line-CodePudding

Home > database > Google Sheets - Find the lowest values in the entire table line by line

Google Sheets - Find the lowest values in the entire table line by line

Time：06-01

I can't find a way to make ArrayFormula and SMALL functions work together using the built-in Google sheets functions.

update:

=INDEX(QUERY(SPLIT(FLATTEN(ROW(F14:F)&"×"&OFFSET(F14;;;9^9; 9^9)); "×");
 "select min(Col2) 
  group by Col1  
  label min(Col2)''"))