texts.tools
HomeAboutPrivacy policy
English
EnglishDeutsch日本語FrançaisEspañol한국어Português繁體中文简体中文العربيةРусскийTürkçeBahasa IndonesiaTiếng Việtไทยहिन्दीΕλληνικάবাংলা
Prepare tables

Excel formula examples

Three templates with English function names: XLOOKUP, UNIQUE + FILTER and COUNTIF. Check your Excel version and language.

Options and rules

0 characters

Related tools

QACheck list linesCount empty lines, duplicate entries and unique values. This does not validate formats.ABCompare textsShow equal, added and removed lines across two texts.DURemove duplicatesRemoves repeated rows from a column or list, just like in Excel.
Prepare tables

How it works: Excel formula examples

Three templates with English function names: XLOOKUP, UNIQUE + FILTER and COUNTIF. Check your Excel version and language.

How it works

Three templates with English function names: XLOOKUP, UNIQUE + FILTER and COUNTIF. Check your Excel version and language.

Input → Result

Input
Excel formula examples
Result
=IFERROR(XLOOKUP(A2,Sheet2!A:A,Sheet2!B:B,""),"")
=UNIQUE(FILTER(A2:A1000,A2:A1000<>""))
=COUNTIF(A:A,A2)>1

Common uses

  • Start an XLOOKUP without remembering every argument
  • Create a unique filtered list
  • Flag duplicate values in a column

Formats and limits

  • There are three presets: XLOOKUP with IFERROR, UNIQUE with FILTER, and COUNTIF. Changing the separator does not translate function names.
  • Function names are English. Availability depends on your Excel version; replace Sheet2 and example ranges. These examples have not been verified in every spreadsheet product or language.

2026-10-07