# Updevly

> Updevly generates, explains, and fixes spreadsheet formulas for Microsoft Excel and Google Sheets.

Home: https://www.updevly.com/
Excel generator: https://www.updevly.com/excel-formula-generator
Google Sheets generator: https://www.updevly.com/google-sheets-formula-generator
Formula explainer: https://www.updevly.com/formula-explainer
Formula fixer: https://www.updevly.com/excel-formula-fixer
Excel error lab: https://www.updevly.com/excel-error-lab
Date workshop: https://www.updevly.com/excel-date-workshop
Conditional formatting: https://www.updevly.com/excel-conditional-formatting
Excel Table structured references: https://www.updevly.com/excel-table-references
Workbook editor: https://www.updevly.com/excel-workbook
Text formula workshop: https://www.updevly.com/text-formula-workshop
Guides search: https://www.updevly.com/guides
Excel vs Google Sheets: https://www.updevly.com/excel-vs-google-sheets
Excel calculators: https://www.updevly.com/excel-calculators
Gallery: https://www.updevly.com/gallery
Hungarian hub: https://www.updevly.com/hu
RSS: https://www.updevly.com/feed.xml
Pricing: https://www.updevly.com/pricing
About: https://www.updevly.com/about
Compared with ChatGPT: https://www.updevly.com/compare/chatgpt
Compared with Copilot: https://www.updevly.com/compare/copilot
Compared with Gemini: https://www.updevly.com/compare/gemini
Compared with Formula Bot: https://www.updevly.com/compare/formula-bot
Excel vs Sheets dialect: https://www.updevly.com/compare/excel-vs-google-sheets-formulas

## Excel formula guides
- XLOOKUP: https://www.updevly.com/excel-formulas/xlookup
- VLOOKUP: https://www.updevly.com/excel-formulas/vlookup
- IF: https://www.updevly.com/excel-formulas/if
- SUMIF: https://www.updevly.com/excel-formulas/sumif
- SUMIFS: https://www.updevly.com/excel-formulas/sumifs
- COUNTIF: https://www.updevly.com/excel-formulas/countif
- INDEX MATCH: https://www.updevly.com/excel-formulas/index-match
- Date difference: https://www.updevly.com/excel-formulas/date-difference
- Percentage formulas: https://www.updevly.com/excel-formulas/percentage
- AVERAGE: https://www.updevly.com/excel-formulas/average
- IFERROR: https://www.updevly.com/excel-formulas/iferror
- CONCAT and TEXTJOIN: https://www.updevly.com/excel-formulas/concatenate
- FILTER: https://www.updevly.com/excel-formulas/filter
- IFS: https://www.updevly.com/excel-formulas/ifs
- TEXT: https://www.updevly.com/excel-formulas/text
- LEFT, RIGHT, MID: https://www.updevly.com/excel-formulas/left
- XMATCH: https://www.updevly.com/excel-formulas/xmatch
- UNIQUE: https://www.updevly.com/excel-formulas/unique
- SORT: https://www.updevly.com/excel-formulas/sort
- COUNTIFS: https://www.updevly.com/excel-formulas/countifs
- ROUND: https://www.updevly.com/excel-formulas/round
- TODAY and NOW: https://www.updevly.com/excel-formulas/today
- SWITCH: https://www.updevly.com/excel-formulas/switch
- SUBSTITUTE: https://www.updevly.com/excel-formulas/substitute
- SUM: https://www.updevly.com/excel-formulas/sum
- AND / OR: https://www.updevly.com/excel-formulas/and-or
- IFNA: https://www.updevly.com/excel-formulas/ifna
- TEXTJOIN: https://www.updevly.com/excel-formulas/textjoin
- MID / RIGHT: https://www.updevly.com/excel-formulas/mid-right
- VALUE: https://www.updevly.com/excel-formulas/value
- DATE: https://www.updevly.com/excel-formulas/date
- EOMONTH: https://www.updevly.com/excel-formulas/eomonth
- NETWORKDAYS: https://www.updevly.com/excel-formulas/networkdays
- INDEX: https://www.updevly.com/excel-formulas/index
- MATCH: https://www.updevly.com/excel-formulas/match
- LET: https://www.updevly.com/excel-formulas/let
- LAMBDA: https://www.updevly.com/excel-formulas/lambda
- VSTACK / HSTACK: https://www.updevly.com/excel-formulas/vstack-hstack
- CHOOSECOLS: https://www.updevly.com/excel-formulas/choosecols
- GROUPBY / PIVOTBY: https://www.updevly.com/excel-formulas/groupby-pivotby
- SUMPRODUCT: https://www.updevly.com/excel-formulas/sumproduct

## Excel task formulas
- Percentage of total: https://www.updevly.com/excel-tasks/percentage-of-total
- Two-criteria lookup: https://www.updevly.com/excel-tasks/two-criteria-lookup
- Working days: https://www.updevly.com/excel-tasks/working-days-between-dates
- Text between delimiters: https://www.updevly.com/excel-tasks/extract-text-between-delimiters
- Running total: https://www.updevly.com/excel-tasks/running-total
- Age from birth date: https://www.updevly.com/excel-tasks/age-from-date-of-birth
- Last non-empty cell: https://www.updevly.com/excel-tasks/last-non-empty-cell
- Text to date: https://www.updevly.com/excel-tasks/convert-text-to-date
- Sum if this month: https://www.updevly.com/excel-tasks/sum-if-this-month
- Highlight duplicates: https://www.updevly.com/excel-tasks/highlight-duplicates
- Domain from email: https://www.updevly.com/excel-tasks/extract-domain-from-email

## Excel errors
- Interactive lab: https://www.updevly.com/excel-error-lab
- #N/A: https://www.updevly.com/excel-errors/na
- #VALUE!: https://www.updevly.com/excel-errors/value
- #REF!: https://www.updevly.com/excel-errors/ref
- #SPILL!: https://www.updevly.com/excel-errors/spill
- #DIV/0!: https://www.updevly.com/excel-errors/div-0
- #NAME?: https://www.updevly.com/excel-errors/name
- #NUM!: https://www.updevly.com/excel-errors/num
- #NULL!: https://www.updevly.com/excel-errors/null

## Google Sheets formula guides
- QUERY: https://www.updevly.com/sheets-formulas/query
- ARRAYFORMULA: https://www.updevly.com/sheets-formulas/arrayformula
- FILTER: https://www.updevly.com/sheets-formulas/filter
- IMPORTRANGE: https://www.updevly.com/sheets-formulas/importrange
- UNIQUE: https://www.updevly.com/sheets-formulas/unique
- REGEXEXTRACT: https://www.updevly.com/sheets-formulas/regexextract
- SPLIT: https://www.updevly.com/sheets-formulas/split
- GOOGLEFINANCE: https://www.updevly.com/sheets-formulas/googlefinance
- IMPORTHTML: https://www.updevly.com/sheets-formulas/importhtml
- BYROW: https://www.updevly.com/sheets-formulas/byrow
- LAMBDA: https://www.updevly.com/sheets-formulas/lambda
- XLOOKUP: https://www.updevly.com/sheets-formulas/xlookup
- SPARKLINE: https://www.updevly.com/sheets-formulas/sparkline
- SEQUENCE: https://www.updevly.com/sheets-formulas/sequence
- TOCOL: https://www.updevly.com/sheets-formulas/tocol
- VLOOKUP: https://www.updevly.com/sheets-formulas/vlookup

## Google Sheets task formulas
- QUERY paid rows: https://www.updevly.com/sheets-tasks/query-paid-rows
- Fill a column: https://www.updevly.com/sheets-tasks/fill-column-with-arrayformula
- IMPORTRANGE: https://www.updevly.com/sheets-tasks/importrange-another-file
- Unique dropdown: https://www.updevly.com/sheets-tasks/unique-dropdown-list
- QUERY group totals: https://www.updevly.com/sheets-tasks/query-group-totals

## Hungarian pages
- Hub: https://www.updevly.com/hu
- Generator: https://www.updevly.com/hu/excel-keplet-generator
- FKERES: https://www.updevly.com/hu/excel-kepletek/fkeres
- HA: https://www.updevly.com/hu/excel-kepletek/ha
- SZUM: https://www.updevly.com/hu/excel-kepletek/szum
- SZUMHA: https://www.updevly.com/hu/excel-kepletek/szumha
- X.KERES: https://www.updevly.com/hu/excel-kepletek/x.keres
- HAHIBA: https://www.updevly.com/hu/excel-kepletek/hahiba
- #HIV!: https://www.updevly.com/hu/excel-hibak/hiv
- #ÉRTÉK!: https://www.updevly.com/hu/excel-hibak/ertek
- #NÉV?: https://www.updevly.com/hu/excel-hibak/nev