Automatically Refresh a PivotTable When its Data Source is Updated PivotTables require a refresh if the underlying data is changed or added to. This tutorial will explain how to automatically refresh your PivotTable using a few lines of VBA code. The solution will work when you change existing data or add new data. Follow the… Read More »Automatically Refresh a PivotTable When its Data Source is Updated
How to Use Excel’s TEXTJOIN Function =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) Excel’s TEXTJOIN function provides a quick way of combining values in different cells, like for example first, middle and surnames as shown below. This has always been possible in Excel but TEXTJOIN provides a better solution if you need to include a delimiter between… Read More »Combine Values & Delimiters Using Excel’s TEXTJOIN Function
SWITCH Function =SWITCH(expression,value1,result1,default) Simple Example To help explain how SWITCH works, here is a simple example. We need the SWITCH function to return the correct discount percentage for each item of fruit in the list D2:G9. The discounts are listed in the first table A2:B6. The fruit value in column D is our expression –… Read More »Using Excel’s SWITCH Function including SWITCH with VLOOKUP.