Happy Friday Excellers. Today let's look at how to generate unique usernames in Excel using the COUNTIF function, even when you have duplicates!. Welcome back for another #FormulaFriday in my #Excel 2020 series of Excel blog posts. I have used this formula to generate usernames for a database. Sometimes there are more than one person with the same name. This great formula in Excel will helps us get over this issue. Here is a list of usernames that has been recently updated with new users. … [Read more...]
Formula Friday – Is That Odd? Testing A Number With ISODD Function.
Hello Excellers, and welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. I kind of like odd things always have done, even this Function looks odd don't you think?. It maybe odd but heck it works if you want to identify odd numbers in you data. ISODD Syntax. =ISODD(number) Where number is the value to test and is a required argument. Let's work through two examples of using this function. Example 1. Testing For An Odd Number. The first example is … [Read more...]
Formula Friday – Count How Many Numbers In A List Are Greater Than The Average Using The COUNTIF Function.
Hello Excellers and welcome back another #FormulaFriday #Excel blog post in my 2020 Excel series. I will share a solution to a question asked recently. How to find how many numbers in your list are greater than the average. This is a useful formula solution using the COUNTIF Function. It can be used to answer a number of questions such as HOW MANY? students scored higher than average employees are paid higher than the average sales reps made sales higher than the average The … [Read more...]
Formula Friday – Quickly Switch From Cell Values To View Formulas – An Excel Shortcut
Happy Friday Excellers!. Welcome to another #FormulaFriday #Excel blog post in my 2020 Excel series. I have a great tip for you. It is really short, but it allows you to quickly toggle between looking at your Excel cell values and view formulas in those cells. I use this on a regular basis, just to check the continuity of my formulas. Switch From Cell Values To View Formulas. It's super easy all you need to do is hit CTRL+' (The 'Grave accent key is is below … [Read more...]
Formula Friday – Copy Formula Down When Formula Is Not Directly Next To Your Data Set
Hello Excellers, and welcome another #FormulaFriday in my #Excel 2020 series. I just love this Excel formula trick, It is a really quick way to copy a formula down a column when the formula is not directly next to your data set. The Usual Double Click Method. Copy A Formula Down. Well, you are probably are aware of the double click quick method of copying a formula down a column. Just position the mouse in the lower right-hand corner of the cell until you see the black cross and … [Read more...]
- 1
- 2
- 3
- …
- 38
- Next Page »
Recommended Excel Resources
