Skip to content

Data Empower – The Data Matrix

Search for:
Log in

Menu

Close
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
Search for:
Log in

Tag: Data

  • Home
  • Data
XL Statistical

QUARTILE.INC Excel function

Written by Data Empower May 22, 2025

Computes the quartile from a dataset.

XL Statistical

PERCENTRANK.INC Excel function

Written by Data Empower May 22, 2025

Calculates the percentage rank of a specified value within a given data set.

XL Statistical

PERCENTILE.EXC Excel function

Written by Data Empower May 22, 2025

Returns the k-th percentile of values within a specified range, where k is between 0 and 1, exclusively.

XL Statistical

MINA Excel function

Written by Data Empower May 22, 2025

Returns the smallest value from a list of arguments, which can include numbers, text, and boolean values.

Xl lookup and reference

MATCH Excel function

Written by Data Empower May 22, 2025

Finds values within a specific range or array

XL Logical

MAP Excel function

Written by Data Empower May 22, 2025

Produces an array where each value from the input array(s) is transformed into a new value by applying a LAMBDA function.

XL Logical

MAKEARRAY Excel function

Written by Data Empower May 22, 2025

Generates a calculated array with specified dimensions by utilizing a LAMBDA.

Xl lookup and reference

LOOKUP Excel function

Written by Data Empower May 22, 2025

Searches for values within a vector or matrix.

XL Logical

LET Excel function

Written by Data Empower May 22, 2025

Assigns labels to results of calculations.

Xl information

ISREF Excel function

Written by Data Empower May 22, 2025

Returns TRUE if the provided value is a reference.

Page navigation

1 2 3 … 6 Next
Follow me on Ganjing World!

Get the SQLBits T-Shirt now!

Copyright © 2025 Data Empower - The Data Matrix | Powered by BuddyX WordPress Theme