Tag: CHOOSE

In my recent post of Fix duplicated Conditional Formatting Rules , I mentioned you should be careful using Conditional Formatting in situations where you have thousands of rows of data or calculations as this can be a drain on performance.  …

Alternatives to Conditional Formatting Read More »

Tagged with: , , , , , , ,

I recently finished a pet project of creating a custom ribbon in XML driven by an Add-In to access my personal macros.   These are the ones you collect over the years and use in your day to day work  to …

My Custom Ribbon using Formulas to Create XML code Read More »

Tagged with: , , , , , , , , ,

If you are working with output from other systems (or preparing input for other systems) you might need to find certain characters that cause problems.  In my case I was creating XML code for a custom ribbon from Excel formulas …

Check range for specific characters Read More »

Tagged with: , , , , ,

We have all done them but there comes a time to find a better way. In Excel 2003 you were limited to 7 levels of nesting but 2007 onwards the level could be increased to 64. Both these levels are …

Avoiding Nested IFs Read More »

Tagged with: , , ,