Formula Friday – SUM Only NEGATIVE Numbers In An Excel Range Using The SUMIF Function.
Happy Friday Excellers. It's #formulafriday time therefore time for another blog post in my Excel series. Today let's look at counting all of the negative values in a data range. This formula is...
It's that time again folks. Time for some more #MacroMonday fun. Today I want to show you how to write a simple #Excel macro that will take a sentence (or a load of text) and split it into...
Add Decimal Places To An Existing Data Set – No Formulas Needed.
Hello, Excellers welcome back to more #FormulaFriday #Excel fun. Today let's look at how to add decimal places to a dataset of existing numbers. Really quickly. (Without using a formula). Here is...
Hi, it is time to write a macro again with my 2019 series of #MacroMonday. So, today let's look at how to write an Excel Macro that protects your worksheets but enables Pivot Tables. This is a...
In Today's #FormulaFriday #Excel tip in my 2019 series let's look at how to sort your data set in random order. We will do this using the RAND Function. This is a really handy tip if you have...
Create Links To All Sheets In An Excel Workbook With A Macro.
Hello Excellers and welcome back to another #MacroMonday #Excel tip in my 2019 Series. I want to share with you a handy Excel macro that will create a hyperlink to all of the worksheets in your...