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...]

## Formula Friday – Paste A Name Into An Excel Formula

Hello Excellers, Friday again and I have a really quick, easy and really useful way to use named ranges you have already created into your formulas. If you need more details on creating named ranges I suggest you take a look at my blog posts below. 3 Reasons To Use Named Ranges In Your Excel Formulas Creating Named Ranges If you want to download the example Excel File used in this blog post then you can do so here If you are happy with named ranges then let's keep … [Read more...]

## Formula Friday – View All Of Your Calculated Fields And Items Contained In Your Excel Pivot Table

Welcome Excellers, Happy Friday and let's have some Excel fun. Today let's look at how to easily see all of your Calculated Fields and Calculated Items that you have created to use in your Pivot Table. After you have added some new Calculated Fields and Items, it can be tricky to keep track of things. We can however see all of our workings and logic with a feature in Excel Pivot Tables that allows us to extract all our Pivot Table Formulas. Here is my basic data set and my Pivot Table I have … [Read more...]

## Formula Friday – 3 Ways To Remove Days From A Date In Excel To Leave Just The Month And Year

Hello again Exellers, today let's look at 3 ways to remove the Days portion from a date in Excel. This was an issue one of my collgeaues came across this week. Let's take a look at the story. He was trying to analyse his data set by Monthly Sales using a Pivot Table. You can see a sample of the data below. The Pivot analysis looks like this; it analysed data the Day and Month together as expected. He just wants Monthly Sales total though. So, my colleague duly selected all … [Read more...]

- « Previous Page
- 1
- …
- 11
- 12
- 13
- 14
- 15
- …
- 19
- Next Page »