Last seen: Jun 2, 2025
Hello, Your latest example corresponds to product 000.000.003 in FBA sheet, where the formula given in my previous post gives profile 10 as result....
Hello, Not really sure I understood you correct Giuseppe, but I give it a try. Check if below formula give correct result in G2. =XLOOKUP(1, (Ta...
Hello, I suppose you are looking for something like burn down and burn up charts. Otherwise I got lots of pages with templates when searching, s...
Hello, A short answer is following formula: =IF(OR(A1<301,AND(A1>=700,A1<1100)),15%,13%) But this is not dynamic in any way. If the ...
Hello, If you can share a file with some sample data, I’m pretty sure we can find a satisfying solution. Br, Anders
Hello, Thank you for your feedback. This is the way the data should be structured, makes it a lot easier to get wanted data from pivot tables and f...
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...