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

30 Day Money Back Satisfaction Guarantee

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.

Have You Seen Click My View Application?

Intelligent Filtering Of Rows AND Columns

 

Hide and Unhide Rows and Columns Instantly

Especially designed for Everyday Excel Users.

Users who want to work faster, easier, smarter,

without technicalities, macros or programming.

Sunshine Solutions Pty Ltd (ABN 30 124 423 552)
34 Balemo St, Minyama, Queensland Australia 4575
Email info@sunshinesolutions.com.au
  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon