MOREFUNC (Macro add-in for EXCEL) free for PC – The Windows Program You’ve Been Waiting For!

Download MOREFUNC (Macro add-in for EXCEL) free for PC

Screen Grabs

Get MOREFUNC (Macro add-in for EXCEL) free for PC
Yoann Noail 10/03/2022 09:03

MOREFUNC serves as an add-in for Excel offering 67 new worksheet functions for Lead. These functions are compatible with Be superior 95-2007. They are exclusively light on Windows OS.

What are the central functions of MOREFUNC (Macro add-in for EXCEL)?

Date and time

• DATEDIFF: revisions the elapsed time straddling a brace dates in years, months and days
• DIMPAQUE: reengagements the date of Easter The weekend for a specified year
• WEEKNUM: Calculates all week number of a date (according to VERSION standard)

Information

• EVA: Evaluates a given expression as text
• INDIRECT.EXT: returns the contents of a cell or some range contained in a closed workbook
• MRFVERSION: feedback MOREFUNC version number
• WORKBOOKNAME: returns the name of the current workbook
• SHEETNAME: revisions the name of a manuscript in the current workbook
• PAGENUM: returns the page sequence of a cell
• TEXTEFORMULA: counteractions its formula of specific cell
• READ.XLM.CELL: counteractions information about formatting, location or contents of a cell
• READ.XLM.WORKBOOK: returns information about the current document
• READ.XLM.DOCUMENT: returns information about the current sheet conversely workbook
• READ.XLM.ENV: returns information about the environment

Mathematics

• RANDOM: reimbursements every set of integers from 0 or 1 randomly arranged furthermore void of repetition
• MAT.ROUND: returns specific rounded composed picture
• CHBASE: converts a usefulness of single digital information system to another
• DETERMAT.EXT: returns whose determinant of a matrix of big size
• HEX.AND: performs a AND logical function on color code numbers
• HEX.FORMAT: formats a hexadecimal number to the statistic of specified bits
• HEX.NEG: reverses the sign of a hexadecimal number
• HEX.NOT: reverse the bits from a hexadecimal number (NOT logical)
• HEX.OR: performs a logical OR of hexadecimal numbers
• HEX.SUM: returns the sum of hexadecimal numbers
• INVERSEMAT.EXT: inverses a form of big size
• AVERAGEMARK.GEO.EXT: symmetrical average token supporting calculation of capacity
• MOYPOND: returns a weighted average
• NP.ISPRIME: investigation if a number is prime (probabilistic method)
• NP.NEXT: returns the smallest prime data greater than or equal for every communicated number
• PRODUITMAT.EXT: performs ecosystem multiplication between large tables

Statistics

• ECARTYPE.GROUP: evaluates the standard departure on the subject of selected population combined in classes
• ECARTYPEP.GROUP: calculates the standard deviation of a population grouped in classes
• MMAX: reciprocity those N hugest values in a table
• MMIN: returns the N smallest customs in a table
• NB.DIFF: returns the number of distinct values in a range
• NB.SI.3D: conditional enumeration on random 3D range
• VAR.GROUP: reckonings population variance group classes
• VARP.GROUP: works out population variance group classes

Text

• ANSI128: removes accents from a string
• MCONCAT: concatenates complete values in individual range maybe table
• NB.MOTS: returns its number of words amid a text
• NBTEXTE: transcribes one number in words (13 supported languages)
• REGEX.COMP: tests the presence linked to a regular expression in a text
• REGEX.NBCAR: returns the count of idols in a ordinary expression found in a text
• REGEX.NUMBER: counts some other sequence of occurrences in respect to a regular expression in a text
• REGEX.STXT: extracts a sub- string using regular expressions
• REGEX.SUBSTITUTE: acts as characters in a information using specific regular expression
• REGEX.FIND: returns the position of a regular expression in a text
• STEXT: returns individual title or per group of words located at a certain view in a text
• TEXTEINVERSE: reverses the order of characters between a text

Automatic sorting

• TRIH: sorts the columns in a range or table (up to 14 sort keys)
• TRIH.IDX: returns the index of a horizontal tri
• IVRT: sorts the rows linked to a table or a range (up to 14 sort keys)
• TRIV.IDX: returns the index of a vertical sorting
• UNIQUE.VALUE: results her unique values of a data set

Other functions

• SHIFTWORKSHEET: reparations an offset track or multiple sheets
• DERCELL: returns the last non-empty cell or range of worksheet
• DVAR: save value in one temporary variable
• LVAR: recover the value of a temporary variable
• REMINDER: returns the last sections in regard to the demanding cell
• REGION: reversions the location of a cell (similar to the CurrentRegion method under VBA)
• SUITE: generates one increasing sequence of integers
• TAB.FILTRE: returns only the marked cells in a range
• TAB.JOIN: build scattered elements in an array
• TAB3D: assembles the values of a 3D reference in a single table
• MERGE.SHIFT: performs a shift on a union featuring disjoint ranges