Hello Excellers, time for a quick bit of Excel Macro VBA coding on a Monday. What could be better?. It is time to get Excel to all the hard work for us if we can right?. Today I will help you remove those annoying page breaks in Excel. You know the ones that insist on staying around even when you have navigated from the Page Break Preview back to Normal View. Now as annoying these are, you can get rid of them with the following process- File | Options | Advanced Display Options For … [Read more...]
Formula Friday- Generate Unique User Names In Excel Using The COUNTIF Function
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...]
Macro Mondays – Convert A Range OF Cells To ‘Proper’ Case With An Excel Macro
Hi Excellers, and welcome back to another #MacroMonday #Excel blog post in my 2020 macro series. It is time to sit up. We will be using the Proper Function today!. You may (or may not) know that you can change the case of text using the Excel PROPER function. What the heck does that mean?. Well, say you have text like this. I lOVE eXcel. If you apply the PROPER formula to this cell, Excel will happily convert your text string to 'I Love Excel'. This is converted to the correct case for … [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...]
- 1
- 2
- 3
- …
- 81
- Next Page »
Recommended Excel Resources
