Search results

To give some background I'm bringing some data from SQL Server into my excel workbook, which I'm then using in a pivot table to display a report summarising 12 months worth of data. To do this I've setup a data connection and have an excel table updating via a view I've setup in my database...

Hi everyone, Have a question about calculated fields to pick your brains about. The current data source for our pivot table analysis is an OLAP cube and it appears that you cannot add in calculated fields when using this as a source. Is this the case of am I missing something? The...

Hi, We have a process that picks up excel workbooks and then processes them into a database. The initial part of this process is to clean the filename to ensure that no illegal characters or symbols are present. The below function removes all symbols etc and also converts letters with...

Hi, I've noticed some strange behaviour in the INDIRECT function between older versions of excel and 2010. I have a workbook that performs a set of looks up against another workbook. The below worked fine: =MATCH(C8,INDIRECT("'[&$A$1&]RP1'!$C:C"),0) C8 is a product code A1 is the name...

Hi Everyone, I've been trying to highlight the first 6 non-zero cells in a range via conditional formatting. I have a test row from A1:L1 with the following values in: 0,0,0,1,2,3,4,5,0,7,8,0 The cells that should be highlighted are those with the values 1,2,3,4,5,7 I was successful in...