Last seen: Mar 8, 2026
Hello, Please view attached copy of your sample file. In sheet Table Example I have restructured your data into a tabular formatted table. As I wor...
Hello, D1 = 2022-09-01 D2 = 2023-08-31 =IF(AND(TODAY()>=$D$1,TODAY()<=$D$2),1,0) This looks very much as an exercise question. Hope I’m...
Hello, Is there any reason to why want to use a range instead of a table for your data? I would simplify your approach by creating an excel ta...
Hello, No file attached. There are some limits for what is allowed to upload, check if your file is within these limits. Image upload cons...
Hello, Even though you have added a data validation list for the cells, it is still possible to write a formula in those cells. The problem is that...
Hello, Check out this blog post about finding free templates, the very first template described seems to be such template you need. Br, Anders
Hello, I would gladly try to help, but there is no sample file I can work with. Br, Anders
Hello, Based on your formula, the section I have highlighted with red text, I can only assume that the date in U1 is greater than the date in F14, ...
Hello, I am not sure what your question is, can you upload a sample file showing what data you have and what you want to get? An alternative method...
Hello, Please upload a sample file with your data. The numbers in your picture says one thing, what you write another. If the sell price for 1 l...
Hello, Seems to me that every order with a created date but no shipped date is to be summed, which should be doable to setup. If you can upload a s...
Hello, You can use XLOOKUP with logical criteria for this scenario, see attached file for an example. =XLOOKUP(1,(lookup_value1=lookup_array1)*(...
Hello Kevin, Unfortunatly, the file upload did not go through. Seems you might have forgot to click the start upload button after you added the fil...
Hello, I took this as an oppurtunity to test myself if I remembered how to twist the functions like in the old days. I would choose the pivot table...
Hello, You need to update the pivot table after any changes made in the source table, just right click in the pivot and choose update. You can read...