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...
Category: Formulas
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...
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...
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...
Hi Excellers, welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel formula series. I really do love the watch window feature in Excel. Being able to monitor numerous cell...
Hello Excellers and welcome back to another #Excel #FormulaFriday blog post in my 2020 Excel series. Today I will show you how to conditionally format an Excel worksheet tab. This is useful if...