Search results

Fixed although I still don't really understand what is wrong with original formula, although think it is something to do with how I have set up the absolute reference. However, by turning off structured referenced and using regular referencing, it instantly fixed the problem. Saves back in...

I have a financial processing spreadsheet that combines data in two final tables on two tabs for month and YTD info at the end after going through a few processing steps in earlier tabs. It worked beautifully when first built, but over last few months performance has dropped of a cliff, with...

Perfect, thanks. I use this all over the place but couldn't see the wood for the trees!

Is there a way to pass a value into formula that references a table, without using INDIRECT function? I have a table set up with multiple columns, one per employee and a row per day, for example Date Weeknum Alfie Bert Charlie 1/1/2019 1 0 1 1 2/1/2019 1 1 1 0 3/1/2019 1 1 1 1 I...

Thanks Chihiro, :) really appreciate your help and taking the time to explain the above.

Thanks very much Chiro and Guido, Really interesting, although confusing. Its more plausible that the change is in Excel rather than differences in sharepoint sites. There is no reason for the users to expand the dimension on the sheet. I could just about believe they may have inserted some...

Thank very much Chihiro, 1. There is formatting within the file including some conditional formatting and groups, but they should be identical in both. 2. There are no pivots in the model - everything is consolidated using SUMIFS to specific locations which change dynamically based on current...

I posted a similar thread a couple of months ago, but am still struggling to get to the bottom of this issue, so trying again to see if anyone can shine a light on what is happening. I was previously called out for cross posting this topic, but as with then, this is the only place I am seeking...

I am still concerned and would like to understand where my thread has been cross posted, although appreciate it might not be appropriate to point to any external site. Is there any way to give me more information, as I said above, I promise this is nothing to do with me. Is there any more...

Hi Hui, thanks for the reply. I haven’t posted this anywhere else, I genuinely don’t know what you are referring to and if it is elsewhere it is nothing to do with me, which is a little worrying. Could you PM me a link to where it is posted. I searched this site in advance, before posting...

Hi, I have a client using a large financial model that I built. It is complex series of sheets, which is a relatively large 19.1Mb in size. After 1 months use, with no material addition of new data, the clients version has increased to over 30Mb. I am at a lose to understand why the file has...

Thanks, this sort of works, but unfortunately I need the brackets for negative rather than an anchored -. I can live with an extra space inside the brackets as it doesn't look like there is a way to strip out with number formatting. The _ doesn't function in same way with space as it does...

Thanks guys, really timely replies, This is my work around and is fine, like you said, no one notices the extra space, its just a shame it doesn't scale as per the comma. I'd prefer not to use CF for the performance reasons you highlight, and I am already using in some areas. You could...

Posted this on stackoverflow, trying here for some inspiration. I want to format some financial data using spaces instead of commas to separate '000's. I am struggling to get the format to scale to larger numbers. Any solution for me needs to by distributed and not use VBA. Excel scales the...

Hi, Another long time lurker. Used the site for ideas regularly and I am now here for some help