Formula Friday – Create A Dynamic Report Header Using The Concatenate Function
I like to automate processes as much as possible and creating report headers for updated monthly reports are no exception to this. If you have the same headers every month, but only the Month name...
Formula Friday- Automating Cell Updates With VLookUp Formula And A Drop Down List
Friday again Excellers...Formula Friday time. Today let's look at how to save time entering data into workbook, by using both a VLOOKUP formula and a data validation drop down list. I want to...
Formula Friday – Permanently Remove A Calculated Field From Your Pivot Table.
Friday again Excellers........Lets look at removing a calculated field from your Pivot Table....Permanently. Sometimes when you create a calculated field in a Pivot Table you may not want to keep...
Formula Friday- Using The Convert Function To Calculate How Long My Task Will Take.
Hello Formula Friday Excellers, today let's look at a really handy formula to help us calculate how many hours a total task from start to finish will take. The whole task is made of a lot of mini...
In a previous Formula Friday Blog Post last week, which you can see here I went through 3 methods to enter formulas into Excel, some quicker than others, and I challenged readers to try methods 1 or...
Friday again Excellers, and today we are going use the COUNTIF function and get Excel to automatically to check how many classes students have signed up for ...or....simply ..count how many times a...