Excel Formulas Archives

Formula Friday – Resize The Excel Formula Bar.

July 23, 2021 by Barbara —4 Comments

Hello Excellers, welcome to another #formulafriday blog post in my #ExcelTips 2021 series. First, let's look at how to see your Excel formulas. It is done more (or less) by resizing the Excel Formula Bar for Excel. Does This Work In All Versions Of Excel?. In versions of Excel earlier than 2007, editing a cell that has a lengthy formula or a cell containing lots of text is not easy. It can often block part of your worksheet. In Excel 2007 onwards, it addressed in … [Read more...]

Formula Friday- Generate Unique User Names In Excel Using The COUNTIF Function

July 2, 2021 by Barbara —1 Comment

Happy Friday Excellers. Today let's look at how to generate unique user names in Excel using the COUNTIF function, even when you have duplicates!. Welcome back for another #FormulaFriday in my #Excel 2021 series of Excel blog posts. I have used this formula to generate usernames for a database. Sometimes there is more than one person with the same name. This great formula in Excel will help us get over this issue by generating unique user names. Here is a list of usernames that has … [Read more...]

Formula Friday – Two Ways To Highlight Today’s Date In Your Excel Dataset

June 25, 2021 by Barbara

Hello, Excellers. Welcome to another instalment of #formulafriday. Today let's look at here a handy Excel Tip if you want to highlight today's date in your Excel data set. I have found this really useful visually where I have sequential dates and want to see where today's date sits in the sequence. You can see from my example data set below, I can easily see today's data with some simple conditional formatting. (..and today's date is 28/12/2017) There are a few … [Read more...]

Count Cells That Contain Text. Excel Tip

June 18, 2021 by Barbara

Hello, Excellers. Welcome back to another #FormulaFriday Excel tip in my #Excel 2021 series. Today I will show you how to count cells in your Excel worksheet that contain TEXT. If you need to count how many of your cells in your Excel range contain text then this is a really easy way to do this. By using COUNTIF and a WILDCARD the solution is easy. How about an alternative solution also?. As always in Excel, there are sometimes a number of ways to get to the same solution. I find it … [Read more...]

Formula Friday – Using COUNTIF Function With Data Validation To Check For Repeating Values In Excel

June 6, 2021 by Barbara

Hi Excellers, welcome to another #formulafriday blog post in my #Excel 2021 series. Data validation is a great way to control data entry into your Excel spreadsheets. The main positive is to promote data integrity to allow easy data analysis. In this example, I will show you how to ensure that a user does not enter any duplicate customer account numbers into your Excel worksheet. This is useful when creating new customer references or accounts which need to be unique. So, I will demonstrate … [Read more...]