potential

I have an attorney billing template in which I enter data as follows in one cell: Office conference with Blank Client regarding freight damage [1.25]; review documents provided by Blank [1.5]; memo to file re potential case [.5]. I would like a formula or way to have all the numbers inside...

G'day all, I see that Google now has it's own macro functionality using a non-VBA language. I'm thinking of exploring it's potential, importing a macro etc., does anyone have any thoughts or experience on this yet? My macros all use features like dictionaries & arrays, will Google Sheets be able...

Please refer to the attached spreadsheet, my property analyzer. You'll see all the columns on the left that show all the important metrics I look for when analyzing potential investment properties. After entering a minimum of data I look to the YEAR 1 COC ROI (COC) (Cash on Cash Return on...

Hi all, I have been given a piece of work to carry on which I am more than happy to do however, there is an element within that has me confused as it just doesn't look or feel right. So the data is laid out like this and is manually updated through templates sent in. <tbody> Value of Batch...

I understand why this happens and how to fix it by making sure there is ample space between pivottables, however I was thinking about a way to tell a user of a potential conflict. Is there something in VBA I could do (a maximumpivot range property or something) that I could run/make to see the...

Hi All, I kindly ask you to help me out on what I'd like to reach. I have a list of numbers (around 100) and I'd like to get all the potential combinations of sums in pairs. To simplify: If I have these three numbers: 1 - 2 - 3, I would like to get the follwing result. 1+1= 2 2+2= 4 3+3= 6...

I cannot open access. The following message appears: A potential security concern has been identified. Warning: It is not possible to determine that this content came from a trustworthy source. You should leave this content disabled unless the content provides critical functionality and you...

Hi all, Hope you're well. I am hoping for some assistance. I am trying to identify if there are any potential duplicate references in my spreadsheet and the system doesn't allow the same reference to be entered twice. So if there is a duplicate, it will somehow be slightly different. IE...