Hello Excellers and welcome to my regular blog spot of #formulafriday. Today is really a double edition as I show you two great ways to find the minimum number in an Excel data set using two Excel functions. The two Excel options we will use are MIN and SMALL. Let's take an example data set of student papers where we have a range of students and their corresponding marks for Math and Geography. We need to identify the minimum value of each of the subjects. Solution 1. Using the MIN … [Read more...]

## How To Create A Variable Drop Down List In Excel – Formula Friday

Hello Excellers and welcome to another #formulafriday blog post. Today let's look at how to create a variable drop-down list in Excel. That's right to be able to choose a value from one cell, and the options then available in your list change depending on the value you have chosen. For example, I have a drop-down selection of Jeans (various styles) which are only available in specific sizes depending on the type of style. So, my Jeans that are Skinny are only available in sizes 8,10,12 … [Read more...]

## Can’t Remember Where Your File Is Saved?. Cell Function To The Rescue

by Barbara

Hello and its #formulafriday again. Today, let's look at a really interesting way to find out where you have saved your file if you can't remember the exact file path. I know that sometimes when I have created, saved and then continue to work on an Excel spreadsheet I cannot exactly remember the file path location I saved the file to. So, let's look at a really quick way to find out where you have saved your current workbook. (Who doesn't forget this now again huh?.). So, did you know that … [Read more...]

## A Formula To Check If You Have Extra Spaces In Your Data – Formula Friday

by Barbara

Welcome Excellers to another #FormulaFriday. Today I am going to show you a great way to check if you have extra spaces in your Excel data that you need to clean up. Sometimes the data in cells looks identical like my barcodes in my sales extract. But, when you try to analyse the data you do not get the expected results. I will show you an example. I have a set of data below that I want to use in a VLOOKUP formula. A simple exercise to use VLOOKUP formula to lookup the barcodes of … [Read more...]

## Sum Cumulatively Across Rows or Down Columns Of Data – Formula Friday

by Barbara

Hello Excellers and welcome back to another #formulafriday blog. Today's tip was a question from a colleague. Thye wanted to know how to calculate a cumulative or running total in your Excel data. Let's looks at a running total in both a row and a column situation. See my same data sets below for both rows and columns. To calculate the running total, we need to combine the simple SUM function with absolute and relative cell references. (By using the $ sign). So in our example, … [Read more...]

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