UDF functions
DVDAddin adds 50 custom Excel functions that behave exactly like built-in ones: type them into a cell, fill them down, nest them inside other formulas.
How to use them
Type =dvd in a cell and Excel lists every function of the add-in; pick one with Tab and carry on typing the arguments. To see the name and meaning of each argument, click the fx button on the formula bar (or press Ctrl+A right after the function name) to open the arguments dialog — DVDAddin functions live in the DVD Functions category, except the three data-query functions dvdSQL, dvdSQLValue and dvdSheets, which live in DVD Addin.
=dvdVnd(F42; 1)
// → "Bằng chữ: Một trăm hai mươi lăm triệu đồng."The argument separator depends on the Windows regional format. This documentation is written for the Vietnamese format and uses a semicolon ;. If your Excel runs on the English (US) format, type a comma , instead of ;.
Practice workbook
Every function has its own sample workbook: in the function's Illustrated walkthrough, click Download this function's sample workbook — the data matches the pictures and the formula cell is already selected. To get all 50 at once, use the full workbook below.
Download DVDAddin-Practice-UDF.xlsx — one sheet per function, named after it, with exactly the data from the guide pictures and the formula cell already selected; the Index sheet gives a formula to try and a link to each function's walkthrough.
All 50 functions
| Function | Group | Purpose |
|---|---|---|
| dvdAIExplain | AI, network & shape | Ask an AI to explain the Excel formula in a cell. |
| dvdAutoHide | Range & lookup | Hide the rows that fail a condition and renumber the rest. |
| dvdColorShapes | AI, network & shape | Recolour several shapes from a list, with transparency. |
| dvdConcatIF | Text | Join the values of a range, with or without a condition. |
| dvdConcatIFS | Text | Join the values of a range that meet several conditions. |
| dvdCountIfColor | Range & lookup | Count the cells whose fill colour matches a sample cell. |
| dvdCountOccurrences | Text | Count how often a substring occurs in a string. |
| dvdELookup | Range & lookup | Return the result of the last matching row. |
| dvdEvaluate | Text | Evaluate the maths expression written after a colon in a string. |
| dvdExplain | Date, number & money | Explain a formula as result = expression. |
| dvdExplainE | Date, number & money | Explain a formula as expression = result. |
| dvdExtractElement | Text | Extract the nth element of a string, keeping empty elements. |
| dvdFilter2DArray | Range & lookup | Filter a two-dimensional array on one column. |
| DVDFx | AI, network & shape | Fetch an exchange rate, latest or for a given date. |
| dvdJoinIF | Text | Merge values matching one condition, optionally removing duplicates. |
| dvdJoinIFS | Text | Merge values matching several range/criteria pairs. |
| dvdLDate | Date, number & money | Write a date as the sentence used in official records. |
| dvdLookupAllSheets | Range & lookup | Look a value up across all worksheets of the workbook. |
| dvdLTime | Date, number & money | Write hours and minutes in words. |
| dvdLTimeDate | Date, number & money | Write time and date together in words. |
| dvdLunarToSolar | Date, number & money | Convert a lunar date into a solar date. |
| dvdMCLookup | Range & lookup | Write every matching row, across several columns, into an output range. |
| dvdMoveShape | AI, network & shape | Move a shape to new coordinates on the worksheet. |
| dvdMVLookup | Range & lookup | Return every matching value from a column offset to the lookup column. |
| dvdNoiSuy | Date, number & money | One-dimensional linear interpolation. |
| dvdPic | AI, network & shape | Insert a picture into a cell, scaled to fit. |
| dvdQR | AI, network & shape | Build a QR code from text and insert it into the cell. |
| dvdSheets | Data query | List the sheet names of a closed Excel file. |
| dvdSolarToLunar | Date, number & money | Convert a solar date into a lunar date. |
| dvdSQL | Data query | Query a closed Excel file with a compact SQL dialect and return the whole result range. |
| dvdSQLValue | Data query | Like dvdSQL but returns a single value — totals, counts, single-cell lookups. |
| dvdSteelWeight | Date, number & money | Steel weight from bar diameter and quantity. |
| dvdStock | AI, network & shape | Fetch the price of a Vietnamese listed share. |
| dvdSumIfColor | Range & lookup | Sum the cells whose fill colour matches a sample cell. |
| dvdSumVisible | Range & lookup | Sum the visible cells, skipping hidden rows and columns. |
| dvdSymbol | Text | Insert a check-box symbol (empty / ticked / crossed). |
| dvdTableLookup | Range & lookup | Two-way lookup by row header and column header. |
| dvdTextJoin | Text | Join several texts or ranges with one delimiter. |
| dvdTextSplitItem | Text | Return the nth item after splitting a string by a delimiter. |
| dvdTranslate | AI, network & shape | Translate text with Google Translate. |
| dvdUnDiacriticsVi | Text | Strip Vietnamese diacritics. |
| dvdUniConvert | Text | Convert VNI or Telex typing into Vietnamese Unicode. |
| dvdUnique | Range & lookup | Return an array of the unique values of a range. |
| dvdUnique2DArray | Range & lookup | Keep the unique rows of an array based on one key column. |
| dvdUniqueV | Range & lookup | Return the unique values, writing the remainder into an output range. |
| dvdUniVba | Text | Turn a Vietnamese string into a VBA string expression. |
| dvdUsd | Date, number & money | Spell a dollar amount out in English words. |
| dvdVnd | Date, number & money | Spell a Vietnamese dong amount out in words. |
| dvdWordCount | Text | Count the words in a string. |
| dvdXlookup | Range & lookup | Extended lookup with error handling and approximate match. |
Functions that need internet or an API key
These four functions pull data from outside the workbook, so they only work with an internet connection:
| Function | Requirement |
|---|---|
| dvdTranslate | Internet connection (Google Translate). |
| dvdStock | Internet connection (VCBS price board). |
| DVDFx | Internet connection; results are cached for one hour. |
| dvdAIExplain | Internet connection and a Gemini API key configured in Tùy chọn (Options). |
DVDFx and dvdAIExplain are asynchronous: the cell shows #N/A waiting... until the answer arrives, then updates itself.
The five groups
- Text — 14 functions for joining, splitting, counting and handling Vietnamese strings.
- Range & lookup — 14 functions for lookups, filtering, unique values, colour-based totals and row hiding.
- Date, number & money — 11 functions for dates, the lunar calendar, amounts in words, formula explanations and steel weight.
- AI, network & shape — 8 functions for AI, live data, QR codes and pictures.
- Data query — 3 functions that read closed Excel files with a compact SQL dialect.