Hello Excellers, welcome to another blog post in my #Excel Tips, #FormulaFriday 2019 series. Today, let's take a look at how to find the address of the cell that contains the maximum number in your Excel data set. Here is my sample data set to work with today. Three Formulas To Solve This Excel Query. To clarify, we actually will be using THREE formulas today to solve this Excel query. We will be using MAX to find the maximum value, MATCH to find the relative position of that … [Read more...]

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

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.

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

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

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