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 – Generate Random Interview Name Lists No Repeats In Excel

I love Friday, as it is time to share more Formula Fun. Today let's look at generating some random names against times slots which are going to use to schedule interview times for potential employees. Download the workbook to follow the example used in the Blog Post. So, in my scenario today, I have a list of interviewees for a job, and to keep things all fair I can use Excel to generate random time slots during the day of interview for each candidate. I have already a list of time … [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 – How To Calculate The Percentage Of Cells In A Range That Contain A Specific String – Using COUNTIF and COUNTA

It's Friday so that means some more Formula Fun. Today let's look at calculating the percentage of cells in a range that contain a specific string. I have used this to as an alternative to a Pivot Table to look at the percentage of customers that each of my companys Sales people represent. It is a straightforward formula that searches in my list of customers and Sales people and returns how many customers each of those Sales people are responsible for. This percentage then changes as we … [Read more...]

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