Excel Product function in Tableau

2018-08-14T19:28:24+00:00 August 14th, 2018|Excel, Tableau|

I stumbled across a question on the Tableau forums asking how to write the Excel Product function in Tableau. Full credit for the answer goes to Brian Bell in the comments of this thread https://community.tableau.com/ideas/1857. The Product formula in Tableau is: EXP (SUM( LN ([FieldName]) ) ) Should [FieldName] be a series of financial returns [...]

Excel unprotect workbook and worksheets using VBA

2018-05-23T07:22:07+00:00 December 9th, 2013|Excel|

I recently inherited some Excel spreadsheets to modify which had protected workbooks and worksheets, but an unprotected VBA project. I didn't have the passwords for the Excel spreadsheets. If the workbook is created in 2007 or below the Excel passwords can be cracked quite easily, there are many links all over the internet which supply [...]

Excel Populate a Combo Box from a Database

2012-04-18T09:47:46+00:00 April 18th, 2012|Excel, VBA|

To populate a combo box on a userform in Excel you need to use VBA. Firstly add a combo box to a userform in the VBA window (Alt-F11) of your spreadsheet. The VBA code below shows how to populate a 2 column combo box. Add this code to the Userform Initialize event to populate the [...]

Remove a line feed / carriage return from a string

2018-05-07T08:25:35+00:00 August 23rd, 2011|Access, Excel, SQL|

If you ever have to deal with long strings of freetext it’s likely you’ve come across random line feed and carriage returns in that text causing you headaches when it comes to manipulating the text. Once you know how it’s quite a simple problem to deal with. This article describes how to remove the carriage [...]

Excel Insert Carriage Return or Bullet Points in a Cell

2011-07-22T10:45:57+00:00 July 22nd, 2011|Excel|

In Excel to insert a carriage return in a cell click into the cell, type the first line, press Alt-Enter, then type the next line. There are different ways to do this depending on what you're trying to do exactly which I found in this article: http://www.officearticles.com/excel/carriage_return_within_a_cell_in_microsoft_excel.htm To enter bullet points in a cell you [...]