Search results

Hi guys, I am using the match formula in the attached file to establish the row in which the first activity takes place on a certain ID. The issue I have is that there are multiple activities that take place on an ID, some of which take place before the Lead ID was created. Hoping that...

Hi all, Attached is a file that uses array formulas and others which ultimately works. The issue I have is when I try to load in thousands of rows of data, it then crashes. Is there a work around to using array formulas such as pivot tables that would achieve the same results and help speed up...

Hi guys, I would like some help with regard to my excel requirement. Within my excel I have a creation date in the following format 20/08/2014 and what I would like to calculate is the difference between it and the delivery date (same format) by number of hours. The issue I have is that there...

Hi guys, Hoping someone can help me... I have multiple pivot tables that include calculated fields. What I try to do in many of my pivots is understand whether TY is up or down on last year by inputting the following formula =(TY-LY)/LY in the calculated field. The issue arises when TY has a...

Hi all, Hopeing someone can help me with this one... I have a large data set on one worksheet and I want to link these records (unqiue only/no duplicates) to another worksheet automatically without having to use a unqiue filter etc... Is this possible? Thanks, Andrew

Hi guys, Hoping someone can help me with this one! I have a large data set on one worksheet whereby I have multiple names list several times in one column and what I want to do is create a link of these names to another worksheet but only want link unqiue records only. Understanding I can...

Hi guys, Having issues when trying to insert a calculated field to calculate a percentage based upon two existing fields (one being a count and the other being a sum). I get the error message #DIV/0! Hoping someone can help me on this, can forward workbook if needs be... Thanks, Andrew

Hi guys, Have recently taken on a new role as a financial data analyst primarily building dashboards, data modeling, commission models, performance tracking, reporting etc... I would like to use excel to make my role easier thorugh macros, data modeling etc... I am by no means an ecel expert...

Hi guys, I have set up numerous pivot tables and pivot charts that are fed from data tabless. The data tables are fed from SAP data dowloads on a regular basis and as such the data from SAP must be copied and pasted into the data table to update the charts and pivot tables. I sm using 2010...

Hi guys, I want to predefine a range of cells with conditional formatting that will automatically remove any letters/words within this range with a blank cell. How can I do this? I know I can you the find and replace function but don't want to add this step to the dashboard. Appreciate the...

Hey guys, Hoping someone can help me with this sumif function I have been TRYING to apply =SUMIF('CEM Q3 2011-Q2 2012'!A3:U6766,B3,'CEM Q3 2011-Q2 2012'!Q3:Q6766) The function returns a 0 although within CEM Q3 2011-Q2 2012'!Q3:Q6766 there are values. It appears that the formula is not...