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...]
The Unique Function In Excel.
Hello Excellers, welcome to another #Excel #FormulaFriday blog post in my 2020 series. Today let's explore the UNIQUE function in Excel. This newly released function is part of the DYNAMIC Array functions announced by Microsoft back in 2018. At that time these array functions were only beta release available to a portion of Office insiders. A few days ago, Microsoft announced these awesome new Excel functions are now available to the Excel monthly Channel. So without any delay let's get … [Read more...]
- 1
- 2
- 3
- …
- 31
- Next Page »
