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 – 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...]
Formula Friday – Flag Multiple Matches In Your VLOOKUP Formula
Hello Excellers, yes it is #FormulaFriday again. Time for some more #Excel formula fun. The VLOOKUP is really great for pulling in data from a larger table in Excel, but sometimes in larger data sets, you can come across multiple values that could be returned from your VLOOKUP. That is to say, more than one match could be available. So just how do we know if there are possible multiple matches?. Use VLOOKUP with IF Statement. We can use the VLOOKUP Formula and this time combine it with an … [Read more...]
- 1
- 2
- 3
- …
- 50
- Next Page »
