Category - Statistical

List of user defined functions

AVERAGEAVISIBLEReturns the average value from the visible, non blank cells in a range (including logical values and text).
AVERAGETOPReturns the average from a range of values only considering the top "x" values.
AVERAGEVISIBLEReturns the average value from the visible, non blank cells.
AVERAGEVISIBLEIFSReturns the average of the visible non blank cells that satisfies multiple condition.
MAXAVISIBLEReturns the largest value from the visible, non blank cells (including logical values and text).
MAXBETWEENReturns the largest value that is between a range.
MAXVISIBLEReturns the largest value from the visible, non blank cells.
MAXVISIBLEIFSReturns the largest of the visible non blank cells that satisfies multiple condition.
MEDIANIFSReturns the middle value in a range of values that satisfies multiple conditions.
MEDIANVISIBLEReturns the middle value from the visible cells.
MEDIANVISIBLEIFSReturns the middle value from visible non blank cells that satisfies multiple conditions.
MINAVISIBLEReturns the smallest value from the visible, non blank cells (including logical values and text).
MINBETWEENReturns the smallest value that is between a range.
MINVISIBLEReturns the smallest value from the visible, non blank cells.
MINVISIBLEIFSReturns the smallest of the visible non blank cells that satisfies multiple condition.
AVERAGEAVISIBLE
Returns the average value from the visible, non blank cells in a range (including logical values and text).
AVERAGETOP
Returns the average from a range of values only considering the top "x" values.
AVERAGEVISIBLE
Returns the average value from the visible, non blank cells.
AVERAGEVISIBLEIFS
Returns the average of the visible non blank cells that satisfies multiple condition.
MAXAVISIBLE
Returns the largest value from the visible, non blank cells (including logical values and text).
MAXBETWEEN
Returns the largest value that is between a range.
MAXVISIBLE
Returns the largest value from the visible, non blank cells.
MAXVISIBLEIFS
Returns the largest of the visible non blank cells that satisfies multiple condition.
MEDIANIFS
Returns the middle value in a range of values that satisfies multiple conditions.
MEDIANVISIBLE
Returns the middle value from the visible cells.
MEDIANVISIBLEIFS
Returns the middle value from visible non blank cells that satisfies multiple conditions.
MINAVISIBLE
Returns the smallest value from the visible, non blank cells (including logical values and text).
MINBETWEEN
Returns the smallest value that is between a range.
MINVISIBLE
Returns the smallest value from the visible, non blank cells.
MINVISIBLEIFS
Returns the smallest of the visible non blank cells that satisfies multiple condition.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext