Hello Excellers, today lets look at an Excel question that a twitter follower sent to me. Their question was 'how do I count how many times a certain word was used or appears in data set'?. Well, that is just the question that can be answered using the COUNTIF formula. See my sample data set below. I want to count how many times the word Apple appears. Right, let's step through the solution using COUNTIF. COUNTIF uses a very simple syntax as there are only two … [Read more...]

## Turn Off Rounding In Excel And Use The TRUNC Function – Formula Friday

Hello, welcome to another #formulafriday blog post for some more formula fun on a Friday - why not?. Today let's take a look and explore the issue of Excel rounding or not rounding numbers. You may have come across this in Excel especially when working with currency values. Rounding your values may work in some scenarios, but you may NOT want to round up figures in some circumstances. Take a look at an example, you may have a yearly charge of a service, which is split between 12 monthly … [Read more...]

## Why Is My Formula Not Auto- Completing When I Type The Equals =Sign – Formula Friday

Hello Excellers, and welcome to another #formulafriday blog post. I want to share with you an issue one of my subscribers had. Their Excel was not behaving as 'normal'. When they began to enter a formula, the formula autocomplete did not appear as expected. I just want to say that I am really pleased to have teamed up with Excel Rescue. If you need help with Excel Fast, Just say the word and they will help. Why not check out their link … [Read more...]

## Back To Basics. Understanding Excel Formula Errors – Formula Friday

Are you ready to get back to basics today with some refreshment of the meaning of the Excel Formula errors that you get sometimes in your worksheets?. It's time to review, and if you are new here then maybe learn just what those pesky (or helpful, depending on how you want to look at them) errors actually mean. Let's talk each error through with an easy to follow example. Understanding Formula Errors. Writing Excel formulas can be east and it can be a bit more challenging. It just depends … [Read more...]

## Generate A List Of Files In A Folder – Without Macros or VBA Code – Formula Friday

Hello, Excellers have you come here for some more #formulafriday fun. Good. Me too!. Today let's look at a really cool way to generate a list of files in a folder without any macros, coding or VBA at all. So this blog post is part of my Formula Friday series. That must mean that we use an actual Excel Formula to carry out this exercise. Well, that is correct. We are going to use a function or formula from the early days of Excel. it is the Files function. Never heard of it?. Don't … [Read more...]

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