Forum

Hello Nesha, As long the users that are to work with any of the three separate files have the master file in same path it will work just fine, if n...

Hello Clio, You can find more guidelines to the techniques used here. What is the syntax of your formula? Is it the exact same as in Mynda’s down...

Hello, Without a file to check it is difficult to give any help. Some questions though that might help us to pinpoint where the issue lies. What...

Hello, In SAP you are able to export data to Excel or CSV, have you tried to export? Br, Anders

Hello, As far as I have been able to find out it seems this functionality to use Get data from online services comes with E3 license. I have not us...

Hello, I don't use Google Drive myself so I can't say if it is possible or not, but if not, then you could perhaps sync the folders/files to a loca...

Hello, Did you check the blog page Phil linked to in previous post? Another good post to read is this about the new dynamic array formulas. I also ...

Hello, Is there any reason to why you do not use a Pivot Table? Attached is an example. Br, Anders

Hello, I would like to help, as also many others in this forum. But as there is no sample file attached I don't see how I can help you out. Br, ...

Hello Alan, One thing we don't have here is how to highlight the cell when we are past those 1095 days, i.e. the renewal period has ended. In attac...

Hello, Just replace the ROW() part in the formula with SUBTOTAL(3,$E$1:$E1), depending on which cell (row) you want to be highlighted you might nee...

Hello, A simple solution. I use Excel 365 and following formula is put in a helper column (B) to do the counting. Also need to add an empty extra r...

Hello, Would love to give some help but without any file to see what's wrong it's impossible. I can guess, but what is the point in that? Please up...

Hello Alan, You can use the DAYS function to get the number of days between start and end date, wrap that in an IF together with an AND statement t...

Hello, I notice you have opened the file in compatibility mode, so the file is most likely saved in the older .xls format. You need to save it as a...