Download
📥 Download: Click Here 👈
💾 Alternative Links: Google Drive | Telegram
Modern Functions Update is a free Microsoft Excel add-in designed to bring new functions inside Excel. Old 2007 or new 365. 32 or 64 bit. It matters not. You will get new functions for free.
✅ 100% Free – Donations: click here!
✅ free version – Donations: click here!
📚 Guide: Coming soon…
What it does:
- Backports modern functions – Use powerful functions like XLOOKUP, FILTER, UNIQUE, TEXTSPLIT, IFS, MAXIFS, and many others even in older Excel versions (from 2007 onward).
- Adds brand-new utilities – Includes functions that don’t exist in vanilla Excel, such as ASK.AI (powered by Ollama or OpenAI), weighted average, if between, and many others.
Compatibility:
- ✅ Win 64 bit & 32 bit
- ✅ Linux* via Bottles
- 📢 Mac? coming soon: Send a request
Currently supported functions
| Class | Function | Notes: |
| 2010 | AGGREGATE | ℹ️ not fully tested yet |
| 2013 | FORMULATEXT | ✅ |
| 2013 | ISFORMULA | ✅ |
| 2013 | NUMBERVALUE | ⚠️ potential issues if OS and Office have different languages |
| 2013 | IFNA | ✅ |
| 2013 | XOR | ✅ |
| 2016 | CONCAT | ✅ |
| 2019 | IFS | ✅ |
| 2019 | MAXIFS | ✅ |
| 2019 | MINIFS | ✅ |
| 2021 | XLOOKUP | ✅ |
| 2021 | XMATCH | ✅ |
| 2021 | UNIQUE | ✅ |
| 2021 | FILTER | ⚠️ Not compatible with old versions. Use FILTERX instead |
| 2021* | FILTERX | ⚠️ introduced for compatibility issues of FILTER |
| 2024 | TEXTSPLIT | ✅ |
| 2024 | TEXTBEFORE | ✅ |
| 2024 | TEXTAFTER | ✅ |
| 365 | REGEXTEST | ✅ |
| 365 | REGEXEXTRACT | ℹ️ not fully tested yet |
| 365 | REGEXREPLACE | ✅ |
| Next | ASK.AI | ✅ |
| Next | EXTRACT_LINK | ⚠️ Requires Macro enable ⚠️ Might not appear while typing in older versions but it is there and fully operational |
| Next | AVERAGE.WEIGHTED | ✅ |
| Next | MAXIF | ✅ |
| Next | MINIF | ✅ |
| Next | IF.BETWEEN | ✅ |
| Next | IF.BETWEEN.B | ✅ |
| Next | COUNT.UNIQUE | ✅ |
| Next | ZLOOKUP | ✅ |
| Yours | Submit a request | 📢 |
Tools on the Ribbon Bar:
| Class | Tool | Notes: |
| Debug | Version Check | ✅ |
| Next | Insert today | ✅ |
| Next | Pick a date | ✅ on Win ℹ️ manual resize needed on Linux |
| Next | Link on/off | ✅ |
Support us
💝 Help up keeping it free 💝
🫶 Donations: click here!