Happy Friday Excellers. It's #formulafriday time therefore time for another blog post in my 2019 series. Today let's look at counting all of the negative values in a data range. This formula is based on the SUMIF Function. So, I have to say it is one of THE most useful functions I find in Excel. It is used to calculate conditional sums, and in the example we will look at today, we will count all of the negative values in a data range. For example I have set up a sample data set to look at … [Read more...]

## Add Decimal Places To An Existing Data Set – No Formulas Needed.

by Barbara

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 our dilemma. So, every week a data set is supplied from my data provider. This data set is good, but every week the data needed to be updated. Decimal places need to be added. A sample of the type of data can be seen below. I need to be able to alter or add two decimal places to the data … [Read more...]

## Sort Your Data In Random Order – Using The RAND Function.

by Barbara

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 a lot of records and you want to randomly take a few to analyze for quality control. For example, I have about 1000 records in my current data set I want to random sort in Excel. A sample can be seen below. We can use the RAND Function and an extra column to randomize the data … [Read more...]

## Find The Missing Numbers In A Sequence. Formula Friday

by Barbara

Hello, Excellers welcome back for another blog post in my 2019 series where I share my #FormulaFriday #Excel tips. Today let's look at a really handy Excel formula or a number of formulas that will tell us what numbers are missing in a sequenced data set. Cool huh?. Let's get writing that formula. We are going to use a number of Excel formulas. We will begin with the logical IF Function. Here is my sample data set. I can clearly see that some of the numbers from 1 to 20 missing. But … [Read more...]

## Using SUM Function Only When Cells Are Ticked

by Barbara

First of all hello, Excellers. A warm welcome back today for another #Excel Tip in my #FormulaFriday series. I will share today a neat way to use the conditional SUM function. I am basing this condition today on cells being ticked or unticked. This tip is based on a question from a subscriber who wanted to sum only the lines on their expenses sheet that's have been paid. These are identified by being ticked on the Excel worksheet. So, let's write the solution to this question. Check … [Read more...]

- « Previous Page
- 1
- 2
- 3
- 4
- …
- 48
- Next Page »