Hi Excellers, this is a different #formulafriday. I want to share with you 3 ways to protect your Excel formulas. So, you have spent a long time preparing your Excel spreadsheet solution, and I bet you don't want anyone to mess up those formulas you have so lovingly created. So there are a few ways to protect some of those most vulnerable parts of your Excel spreadsheet. Here are my top 3 ways to protect your Excel Formulas!! Hide the Formulas. Lock The Cells That Contain … [Read more...]

## Formula Friday – How To Calculate The Percentage Of Cells In A Range That Contain A Specific String – Using COUNTIF and COUNTA

It's Friday so that means some more Formula Fun. Today let's look at calculating the percentage of cells in a range that contain a specific string. I have used this to as an alternative to a Pivot Table to look at the percentage of customers that each of my companys Sales people represent. It is a straightforward formula that searches in my list of customers and Sales people and returns how many customers each of those Sales people are responsible for. This percentage then changes as we … [Read more...]

## Formula Friday – Let’s Use TEXTJOIN To Join Text Strings Without The CONCATENATE Complexity

Happy Friday Excellers. If you have Excel 2016 then you maybe already aware of some of the new functions that are available. One of thos functions is TEXTJOIN, and also CONCAT which was introduced in February 2016. I have been using TEXTJOIN recently to replace the function I used on a regular basis ---CONCATENATE, and I get the same results, without the hassle the CONCATENATE brings. Want To See How Simple TEXTJOIN is? Let's carry out the same process, first with CONCATENATE then … [Read more...]

## Formula Friday – How To Easily View Your Formulas With FORMULATEXT Function In Excel

This handy function is available from Excel 2013 onwards, unfortunately it is not available for earlier versions of Excel. Sorry guys..... but if you do have Excel 2013....here you go... FORMULATEXT So what does FORMULA TEXT do?. Simply put it returns a formula as a text string.... Or in other words it writes your formula in a cell as a simple text string- exactly what you see in the formula bar if you click on a cell that contains a formula. This feature is really useful to … [Read more...]

## Formula Friday – Whats The Difference Between An Excel Formula and A Excel Function?

Let's get back to basics today in #formulafriday and discuss something I am asked quite frequently about...... What is the difference between a Formula and a Function in Excel? If you use Excel as a rather large calculator then you have probably used it to do something like this- ( the result being 23) =1+2+4+6+10 or =A1+A2+A3+A4+A5 What you have done in Excel right there in the example above is used a Formula. If you find this useful, then that is great, but Excel is way more … [Read more...]

- 1
- 2
- 3
- …
- 12
- Next Page »