Hello time for some more #FormulaFun. Today we are looking at using the TEXT function to add leading zeros to numbers. In certain situations you may need to have data displayed with leading zeros. For example -customer ID records, or in my case I use store numbers in my databases and I add leading zeros to maintain data consistency for example 00564 and 03453 as the store ID's. I know I will never use these fields in any calculations, (I am never going to add the actual value of the … [Read more...]

## Formula Friday – Randomly generate words in Excel with INDEX and RANDBETWEEN.

Happy Formula Friday. If you want to download the example Formula Friday workbook then you can do so here. I like generating random data a lot of the time to test out work sheet solutions. I have been asked by one of my subscribers to show how to generate some random names from a list of names that are contained in a data set or table. We can do this with ease in Excel, by using both the INDEX and RANDBETWEEN functions together. What are we waiting for???. Here is a same list of … [Read more...]

## Formula Friday – Sum Formula Not The Best Solution? Try Subtotal!

Today's Formula Friday will be looking at the Sum Function vs the Subtotal Function. If you want to download the Formuala Friday examples you can so so here Even though SUM is probably one of the most straightforward and most used formula in Excel, it sometimes does not serve so well in certain situations. Ever tried to use SUM in these scenarios? Try to calculate Sum Total when you have hidden or filtered rows Try to calculate Grand Total when you have Sub Totals in your data … [Read more...]

## Formula Friday – 3 Ways To Protect Your Excel Formulas

Hi Excellers, this is a different #formulafriday. I want to share with you 3 ways to protect your Excel formulas. So, you have spent a long time preparing your Excel spreadsheet solution, and I bet you don't want anyone to mess up those formulas you have so lovingly created. So there are a few ways to protect some of those most vulnerable parts of your Excel spreadsheet. Here are my top 3 ways to protect your Excel Formulas!! Hide the Formulas. Lock The Cells That Contain … [Read more...]

## Formula Friday – Find And Hide All Formulas On An Excel Worksheet

Happy Formula Friday Excellers, today let's look at an awesome way to quickly find all of our formulas on an Excel worksheet and hide them. Today's post is in response to a question I was asked recently, as a colleague needed to find all of the cells on a (big...very big) Excel worksheet and hide them, so the worksheet could be distributed without fear of all of their hard work on their formulas being undone, with the click of an end users (clumsy) mouse. I do myelf often hide formulas, … [Read more...]

- « Previous Page
- 1
- 2
- 3
- 4
- 5
- …
- 21
- Next Page »