Search results

Hi guys, Really appreciate your help on this, I removed multiple rows and and columns of data before sending which are probably the cause of the latency. What I have now works and am willing to wait an hour for a weekly refresh. A quick question, is there a way I can calculate just one column...

Hey @Somendra Misra , Sorting by ID and then by time allows formula to work. The only issue is latency within the file, it took me an hour to update. If there was a work around to the array formula (which works great, thanks), it would be much appreciate and help me out a lot! Thanks again...

Hi @Somendra Misra, On second observation, while the formula captures an activity that takes place after the Lead ID creation date it doesn't appear to capture the first activity post the Lead ID creation date. Can the formula be updated to achieve this or would a secondary sort on the activty...

Hey @Somendra Misra, Formula works like a charm, if only my file was a little smaller it would be perfect. Thanks, Pitcher

Thanks @Somendra Misra, The file I sent is a sample file, my actual file is much larger. The fear I have in using an array formula is that it will cause too much latency for my file to actually calculate. Is there an alternative workaround? Cheers, Pitcher

Thanks @NARAYANK991, That is correct. The formula I currently have in there does not incorporate the greater than or equal to element. In some cases on the PLL tab for the ID there may not be a corresponding entry on the AOL tab. For these instances I would like to keep this cell blank...

Thanks SM, The formula in column N works but does not give me what I want. Example - 00Q60000012uuM9 on pushlead lead tab (row 1225) Row of first contact is 2258 which when looking at the activities on leads tab is 16/10/2014. The issue I have is that the Lead Id on the pushlead tab was...

Hi SM, My query relates the column N within the "Pushlead Lead" tab, please read detailed comments. In this column I have established the row in which the first activity on the Lead ID takes place from a a time perspective (from the "activities on Leads" tab) but in some cases the first...

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...

Hey Luke, Appreciate the help, this should hopefully help the latency. Before I load in some more data... So just two things: 1). there are one or two anomalies, Row 5 (has a first touch date but there are no touches), Row 317 (there are 4 touches but the corresponding activity and time to...

Hi @NARAYANK991 , Thanks for jumping in here. @Luke M if you had time to look at this I would very much appreciate it. I understand that a robust alternative to the approach within the file will take some time but if any of you guys could help it would be awesome. The issue I have is...

Hi Narayan, I know you probably get this all the time but I am hoping you can help me with my query/task which @Ashessh has really helped me out on to date. The link to my thread and latest data file below. The issue I have is using array formulas that are causing latency within my file...

Thanks Asheesh. Like you said the array formulas are causing too much latency still for this to be a viable solution. Great for smaller quantities of data though. Is there anyone I can reach out to who may also be able to help? Tried reaching @Hui but not sure I am doing it correctly...

Ashessh, Unfortunately when I load more data into the tables it falls over. Is it possible to replicate the formulae without the use of the tables? Ultimately it would be awesome to somehow have something automated/robust that returns the same data whilst allowing more data be loaded. Cheers...

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...

Asheesh, Thanks again for your help on this! All the formulae in place now returns exactly what I want. If over the course of the next day or two you get a chance to somehow achieve the same results in a less excel strenuous manor (pivot tables or otherwise) that would be awesome! This would...

Hi @Hui @Asheesh who has helped me enormously so far I know is busy. Hoping you had could help me or point me in the right direction regarding my file and task. Under pressure to find a robust solution (should there be one) so would really appreciate any help on this. If any additional info...

Hi Asheesh, Is there a way I could use pivot tables for each field that I am trying to calculate? If so I would be very grateful if you could show me how this can be done as this would allow me refresh the file much quicker than is currently possible using the array formulas. Cheers, Andrew

Thanks Asheesh, When counting the number of touches I used a pivot table and then worked a sumif formulae off it. The piece I couldn't incorporate was the post creation date piece. If you have time, it would be great to include any alternatives to the using the array formulae in there at...

Hey Asheesh, The example you provided is correct. What I want to capture is the time of the first touch post the creation date. Should there be none then please leave blank. Same principle applies for the "activity type". Is it possible to count the number of touches on each ID using the same...

Hi Asheesh, The latest file you sent me on Tuesday was great. I am hoping to update the existing formulae for "first touch" and "activity type" to only capture the first touch and activity type post the creation date. Don't think the "time till first touch (bus hours)" formulae needs to be...

Thanks Ashessh, I wonder is there an alternative way to achieve the same results. The data set is massive and as a result Excel will not process the formulae. If the earliest/first created date for each contact and Lead ID was included in a new column beside each row item, could a conditional...

When I try to extend the range the formale changes where I cannot add back in the parenthesis/brackets at each end.

Essentially what I would like to do is add the data and be able to drag the formulae down...

Thanks Asheesh! As I will be adding in thousands of rows of additional data, would it be possible to write the formulae for an entire column as opposed to the specified sample data I provided? Cheers, Andrew