Last seen: Mar 8, 2026
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...
Hello, Go to Data menu, on the left hand side you find From text, click on that and the Data import guide starts. Navigate to your .txt file and op...
Hello, For more in deapth guidance on how to use Conditional Formatting, please check this blog post, it covers the most you should know. As I d...
Hello, Notice when opening the .txt file following your steps that number values containing period (.) is regarded as text while those only contain...
Hello, I assume you also made the ALL query as a connection only. If so then you need to right click the query and choose Load to... option and the...
Hello, Have you considered using Power Query to import the data from the SharePoint list? Br, Anders
Hello, I don't know how familiar you are with Pivot Tables, but in attached file is a simple example where I have the data in an Excel table and th...