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

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

## Formula Friday – 2 Ways to Switch First And Last Names In Cells In Excel

Today's blog post was actually a question from one of my colleagues at work earlier this week, they had a list of first and surnames of employees, seperated by a comma, with the surname first and the first names last and they needed to switch them around for example ,from "Green, John" to" John Green". So let's look at two of the ways we could easily do this in Excel. The first method involves 2 steps. Method 1. Text To Column & TextJoin First we can use Text To Columns to … [Read more...]

- « Previous Page
- 1
- …
- 11
- 12
- 13
- 14
- 15
- …
- 21
- Next Page »