Happy Friday!...time to Excel with another #formulafriday blog post in this series. Today let's take a look at how to prevent duplicate name or employee ID numbers in a worksheet. So, how do we do that,?. We can create a simple solution with Data Validation and the COUNTIF Function. So for today's example, we are going to use a really simple data set. It consists only of Employee ID's. Your data set will be more complex but we are only looking to only perform an action on one column of … [Read more...]

## Formula Friday – Setting Excel To Calculate Formulas Manually

by Barbara

Happy #formulafriday Excellers and welcome to another blog post. Today let's look at setting Excel to calculate formula manually. If you are working on large spreadsheets, they may take some time to update and calculate especially if you have a slow pc or laptop. A great easy way to avoid this happening is to cut short the updating time by switching the Excel formulas to calculate manually or on demand not automatically. To Download The Associated Files For This Formula Friday Series 2019 … [Read more...]

## Formula Friday – FLOOR Function In Excel- Find Out The Decade That Song Was From

by Barbara

Happy Friday Excellers and welcome to another #formulafriday blog post. I found this little Excel formula out by accident. I was trying to find out what decade a date was from and thought it may have its uses along the way in Excel. Whilst most numbers will let you round up or down to a specific decimal place, the FLOOR function will allow you to specify yourself what number you want to round down to. Basically, this function will round a number down to zero, to the nearest multiple of … [Read more...]

## Formula Friday – When Your Formula Is Not Calculating As You Expected? Is Excel Wrong!?!? Displaying decimals versus Rounding in Excel

by Barbara

Hello and welcome to yet another #formulafriday blog post. I want to share today with you an Excel formula problem a colleague of mine asked me to look at a week or so ago. So, I thought it would be worth sharing here with you. If you want to download the workbook for the #formulafriday 2019 Season then click on the link below. I was asked to look at worksheet which calculated the price of goods, a discounted price of goods and the price of goods converted from Sterling to … [Read more...]

## Find The Maximum Value In Your Data Set WITHOUT a Formula

by Barbara

Hello Excellers and welcome back to another #formulafriday blog post. Today is a little different as we will not be using a formula. For this great Excel tip, we actually do not even need to type an equals sign. In fact, we do not need to enter anything into a cell to calculate the maximum value in our data set. So I guess this is a #notaformulafriday blog post. Go figure!. Let's start with a data set a bit like my example below. We want to find the largest or the maximum value in the … [Read more...]

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