Similar and Alternative Excel Functions to SMALL

Similar and Alternative Excel Functions to SMALL

Categories
undefined
  •  LARGE belongs to the Statistical category. 👉 undefined.  LARGE performs Calculation operations. 👉 undefined.  LARGE needs 2 required arguments 👉 SMALL needs same number of arguments as LARGE.
  •  AVERAGEIF belongs to the Statistical category. 👉 undefined.  AVERAGEIF performs Calculation operations. 👉 undefined.  AVERAGEIF needs 2 required arguments 👉 SMALL needs same number of arguments as AVERAGEIF.
  •  COUNTIF belongs to the Statistical category. 👉 undefined.  COUNTIF performs Aggregation operations.  COUNTIF needs 2 required arguments 👉 SMALL needs same number of arguments as COUNTIF.
  •  COUNTIFS belongs to the Statistical category. 👉 undefined.  COUNTIFS performs Calculation operations. 👉 undefined.  COUNTIFS needs 2 required arguments 👉 SMALL needs same number of arguments as COUNTIFS.
  •  MODE belongs to the Statistical category. 👉 undefined.  MODE performs Calculation operations. 👉 undefined.  MODE needs 1 required arguments 👎 SMALL needs fewer arguments than MODE.
  •  SUMIF belongs to the Mathematical category.  SUMIF performs Calculation operations. 👉 undefined.  SUMIF needs 2 required arguments 👉 SMALL needs same number of arguments as SUMIF.
  •  IFERROR belongs to the Logical category.  IFERROR performs Calculation operations. 👉 undefined.  IFERROR needs 2 required arguments 👉 SMALL needs same number of arguments as IFERROR.
  •  COUNT belongs to the Mathematical category.  COUNT performs Calculation operations. 👉 undefined.  COUNT needs 1 required arguments 👎 SMALL needs fewer arguments than COUNT.
  •  AVERAGE belongs to the Statistical category. 👉 undefined.  AVERAGE performs Calculation operations. 👉 undefined.  AVERAGE needs 1 required arguments 👎 SMALL needs fewer arguments than AVERAGE.
  •  DSUM belongs to the Database category.  DSUM performs Aggregation operations.  DSUM needs 3 required arguments 👍 DSUM needs fewer arguments than SMALL.