Smart Function Bundles
50+ Functions To Save You Time & Ease Your Workload
Every Function Will Either Save You Time, Ease Your Workload or Add Capability To Your Spreadsheets
It's So Easy - For Example:
Copy And Paste Formulas As Values Can Be Automated With
=CMV_Paste_Cell_Value(A1, FormulaRange)
There Are Three Function Bundles
Plus A Combo Bundle Containing All Three
Cell Functions
Processing Functions
External Functions
PLUS Bonus Functions
Bonus Functions In Each Bundle
-
Backup Button - saves time-stamped backup of the workbook
-
Get Cell Formula
-
Get Cell Formula With Cell Address And Result Value
-
Get Regional Date Format
-
Set Cell To TRUE, FALSE, NULL (3 functions)
- Wait n Seconds
-
Is This Mac OS or Windows Environment
-
F9 Calculate with Zero response - use this in calculation formulas
-
F9 Calculate with Null response - use this in textual formulas
Bonus Functions Are Included In Every Pack
30 Day Money Back Satisfaction Guarantee
Cell Based Functions Bundle
-
Change Cell Color - using an RGB code
-
Change Cell Color To An Excel Named Color x 8
(Black, White, Red, Green, Blue, Yellow, Magenta & Cyan) -
Clear Cell Range
-
Get Cell or Range Address as a string
-
Get Cell Color - as RGB code
-
Get Cell Height
-
Get Cell Width
-
Is Cell Hidden?
-
Is Cell Within a Range?
-
Is Column Hidden?
-
Is Row Hidden?
-
Paste Cell Formula or Range of Formulas to another range.
Use it for Copy Paste range, Fill Down and Fill Across -
Paste Cell Value or Range of Values to another range
Use it for Copy Paste range, Fill Down and Fill Across -
Paste Formula String To a Cell or Cell Range
Use it To Paste to a Range, Fill Down and Fill Across with a Fixed Formula string OR User Generated string Formula in a cell -
Paste Value To Cell Range - Paste range, Fill Down and Fill Across
-
Transpose Cells x 4 functions
Copy and Move From Columns Into Rows
Copy and Move from Rows Into Columns -
Bonus Functions
We accept these and other cards
Special Offer - One Time Purchase
Save 50% - Only $29.99
30 Day Money Back Satisfaction Guarantee
General Processing Functions Bundle
-
Clean A String - Thorough Clean - Removes ALL Non Printable Characters - including new line, line feeds, ALT new line and carriage returns.
-
Concatenate Cell Range - single & multi range, non contiguous cells + options for separator, skipping blank cells & date handling
-
Convert Column Number to Column Letter(s)
-
Find All Duplicates - single & multi range, non-contiguous cells, highlight them in colors of your choice, including first occurance.
-
Find Duplicates - single & multi range, non-contiguous cells, highlight them in colors of your choice, excluding first occurance.
-
Get Last Used Range Cell Address
-
Get Last Used Range Column
-
Get Last Used Range Row
-
Get nth Word or Phrase in a string
-
Get nth Word or Phrase in CSV string - text between commas
-
Search Exact Match - Multi-Criteria - string or CSV
-
Search Partial Match - Multi-Criteria - string or CSV
-
Search Word or Phrase Match - Multi-Criteria - string or CSV
-
Bonus Functions
Special Offer - One Time Purchase
Save 50% - Only $29.99
We accept these and other cards
30 Day Money Back Satisfaction Guarantee
External Functions Bundle
-
Export Cell Range as Excel CSV File
-
Export Cell Range as Excel TEXT File
-
Write File Row (Text String) - With Append option
-
Read File Row (Text String) - With read row n option
-
User Alert Message Box - OK!
-
User Action Message Box - Yes/No
-
Get Current Workbook File Name
-
Get Current Workbook Path
-
Get Active Sheet Name
-
Is File Or Directory Present?
-
Is A WorkBook Open?
-
Is A WorkSheet Present?
-
Bonus Functions
Special Offer - One Time Purchase
Save 50% - Only $29.99
We accept these and other cards
30 Day Money Back Satisfaction Guarantee
Combo Functions Bundle
We accept these and other cards
Get All The Functions Included In
Cell Based Functions Bundle
General Processing Functions Bundle
External Functions Bundle
Plus Bonus Functions
Special Introductory One Time Purchase Offer
Save 50% - Only $59.99
Get All Three Bundles For The Price Of Two
Future Functions
Our functions are specially designed to help every-day Excel users to save time,
by using simple formulas that really do save time and effort in Excel.
Our development plans include extensions to some of the existing functions, new and complimentary functions for the existing packs, plus some new packs.
All are aimed at saving you time in your day-to-day work.
Please join our mailing list for news and updates
We welcome your feedback on how to improve our functions.
We also welcome feedback on what else would help you to save time working with Excel.
Just drop us note using the contact form below.
Inclusions When You Purchase A Functions Bundle
An Excel Add-In pack includes all the functions for that bundle, plus the Common Functions, as defined in the Functions Directory at time of purchase.
1 Computer Licence Per Pack (unless specifically stated otherwise)
Functions Directory, detailing functions, arguments and options
A pdf file of the examples workbook for easy reference
The examples workbook for the functions pack
Access to all demonstration workbooks
Access to All How To Videos
30 Day Money Back Satisfaction Guarantee
The licence is valid for all users of that computer, does not have an expiry date and whilst tied to the computer it is first installed on, it can be moved a number of times.
System Requirements
Our function are Excel Add-In Files (xlam)
All functions are specially designed for inclusion in formulas
(functions do not reside within or alter your workbooks)
Works with XLSX, XLSM and XLSB workbook formats
In Excel 2010, 2013, 2016, 2019 - 32 / 64 bit
Windows 32 / 64 bit
Note: Macros must be enabled
Sorry, but please do not purchase if you have a Mac
We are aware of some critical differences with Mac Excel that we must address.
We are planning on doing so in the near future and will keep you advised.
Please join our mailing list for news and updates
Note: The functions are designed & built to be called from formulas.
Many will work when called from vba, but there is no warranty or
guarantees if called from vba code.
