VSTO & .NET & Excel

September 3, 2013

Great Articles based on Formulas only!

Filed under: .NET & Excel — Dennis M Wallentin @ 5:54 pm

Whenever I see solutions in MS Excel without the use of VBA it actually reveals the core power with functions and formulas. That’s why I want to highlight the excellent work made up at “E90E50fx….only formulas”.

It says “…only formulas” however it exist at least one article that includes VBA. But they are forgiven 🙂

The following link will take You to the site: https://sites.google.com/site/e90e50fx/home

Now I will go back to other activities excluding MS Excel!

Enjoy!

Kind regards,
Dennis

Advertisements

2 Comments »

  1. Hi Dennis. If you like formulas, no doubt you’ll also like the challenges and responses posted at http://chandoo.org/forum/forums/excel-challenges/
    The challenges all call for a single formula, and some of the standouts include:
    * working out if a number above 1048576^2 is a prime number (meaning you can’t simply generate a consecutive array of integers based on the number of rows in a worksheet)
    * producing distinct/duplicate/unique arrays from a list containing text AND numbers
    * Counting the number of times a numeric array occurs in another
    * Doing Two-way interpolation
    * Turn non-contiguous, different sized 1D ranges into one 1D range

    Hours of fun!

    Also, Mike Girvin’s YouTube channel has some great stuff along the same lines.

    Comment by Jeff Weir — September 4, 2013 @ 7:34 am

    • Jeff,

      Thanks for the heads up with Chandoo’s challenges. I have added it for a coming articles.

      Kind regards,
      Dennis

      Comment by Dennis M Wallentin — September 4, 2013 @ 1:16 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: