View Single Post
Old 09-28-2020, 12:46 PM   #19
Dorianmode
always learning
 
Dorianmode's Avatar
 
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
I think there must be a way to be able to add the filtering formula, (used above) for the Excel "Small" function read outs. Right now, in the sample above, that doesn't work. I'll have to play with the SUMPRODUCT functionality, and see if I can get it to work.

Meanwhile, I came across this very helpful list of formulas, and explanations, for use in Excel.
https://exceljet.net/formulas
Dorianmode is offline   Reply With Quote