I’m working on a dashboard for a client and I’ve set it up so that they can choose which month they want to display in their report. When they choose a new month the header in the report automatically updates to show the new ‘From’ and ‘To’ dates. New data is added daily, so at [...]
November 2011
What say you want to find the percentage increase or decrease for the last value in a list compared to the minimum? Sure you could do it the manual way, but I’m going to show you a way you can update the calculation automatically each time a new value is added to the bottom using [...]
You may already know you can find the 3rd highest value using the LARGE function, but what if you want to average the top 3 values in a long list like the one below? Download the workbook and follow along. You could use a PivotTable, or a fixed array within a LARGE function like this: [...]
Do you ever want to extract a list of unique records from a massive list like the one in column A below which has over 900 records? It would be tiresome to copy and paste the list and then delete the duplicate lines. Of course we could use the Remove Duplicates tool on the Data [...]
It’s ok, no zebras get hurt in this process, it’s actually all built in to Excel’s Conditional Formatting Conditional Formatting – Shade Alternate Rows To create this effect we need to create a new rule which uses a formula to determine which cells to format. Conditional Formatting Using a Formula Select the cells you want [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
