MODE.SNGL Function in Excel: The Most Frequent Number
MODE.SNGL returns the value that appears most often in a set of numbers.
Read article →ISFORMULA Function in Excel: Does the Cell Hold a Formula?
ISFORMULA Function in Excel: Does the Cell Hold a Formula?
ISFORMULA returns TRUE when a cell contains a formula. Use it in conditional formatting to catch numbers someone typed over a formula column.
Read article →SEARCH Function in Excel: Position of Text (Any Case, Wildcards)
SEARCH Function in Excel: Position of Text (Any Case, Wildcards)
SEARCH works like FIND but ignores case and accepts wildcards (? and *). With ISNUMBER it becomes a “contains” test.
Read article →ISREF Function in Excel: Is It a Valid Reference?
ISREF Function in Excel: Is It a Valid Reference?
ISREF returns TRUE when its argument is a reference. With INDIRECT it checks whether a sheet name typed by a user exists.
Read article →Group Customers Automatically with K-Means in Python (From an Excel File)
Group Customers Automatically with K-Means in Python (From an Excel File)
Use k-means clustering to split customers into segments by orders, spend and recency — reading from and writing back to Excel with pandas and…
Read article →COLUMN Function in Excel: Column Number of a Cell
COLUMN Function in Excel: Column Number of a Cell
COLUMN returns the column number (A = 1). Handy for VLOOKUP formulas that fill across.
Read article →DAVERAGE Function in Excel: Average With a Criteria Table
DAVERAGE Function in Excel: Average With a Criteria Table
DAVERAGE averages a column for rows that meet the criteria range.
Read article →ENCODEURL Function in Excel: Make Text Safe for a URL
ENCODEURL Function in Excel: Make Text Safe for a URL
ENCODEURL converts spaces and symbols into URL codes (%20 and so on).
Read article →COUNTIF Function in Excel: Count Cells That Meet a Condition
COUNTIF Function in Excel: Count Cells That Meet a Condition
COUNTIF counts cells that meet one condition. It is also the simplest duplicate checker.
Read article →DCOUNT Function in Excel: Count Numbers With a Criteria Table
DCOUNT Function in Excel: Count Numbers With a Criteria Table
DCOUNT counts numeric cells in a column for matching rows. Use DCOUNTA to count any non-blank cell instead.
Read article →CONCATENATE Function in Excel: The Old Way to Join Text
CONCATENATE Function in Excel: The Old Way to Join Text
CONCATENATE joins text pieces. It still works for compatibility, but it cannot take a range — CONCAT and TEXTJOIN replaced it.
Read article →ISTEXT Function in Excel: Is It Text?
ISTEXT Function in Excel: Is It Text?
ISTEXT returns TRUE for text — the quickest way to find numbers or dates that were imported as text.
Read article →