Excel Tip. Highest And Lowest Selling Price of Product Using MINIFs and MAXIFS.
Today's Excel tip is a question I was asked recently by a subscriber. It was to achieve an easy way to find the lowest and highest selling prices for a range of products. So, Welcome back to...
Hello, Excellers welcome back for another Excel blog post in my 2020 series where I share my #FormulaFriday #Excel tips. Today let's look at a really handy Excel formula or a number of formulas that...
Enable Your Personal Macro Workbook. Help! Where Did It Go?.
Hello Excellers and welcome back for another #Excel #MacroMonday blog post in my Excel 2020 series. Today is a quick (ish) macro or VBA tip in response to a question I have been asked recently. A...
Formula Friday- 3 Fastest Ways To Apply A Formula To An Entire Column Or Row In Excel
Happy Friday Excellers, time for more #FormulaFriday Excel Fun. Today I want to show you how the 3 fastest ways to apply a formula to an entire column or row. I am always looking for ways to be be...
Hello, Excellers welcome back to another #MacroMonday #Excel blog post in my 2020 Excel and VBA series. Do you do the same thing over and over again in Excel?. DO you want to get...
Have you had or are having issues with Excel? If indeed you are having issues it may be due to some files or Add Ins that are loaded as Excel starts. In order to troubleshoot or test this theory...