Modern Functions Update

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	📢

💝 Help up keeping it free 💝
🫶 Donations: click here!