Last seen: Jun 15, 2025
Hello, No file attached, but there is no need to upload (unless I understood your query wrong). Do check out the blog article Excel Table Absolu...
Hello, Perhaps a Power Query solution is something that would work. Added a custom column using Date.ToText. = Table.AddColumn(#"Omsorterade kol...
Hello, You can use different FUNCTIONS to lookup and fetch a value. XLOOKUP SUMPRODUCT INDEX & MATCH See attached copy of your sample...
Hello, Not a fully correct result, but perhaps it can be adjusted further. I am not good with VBA so I haven't checked for such solution. Asking...
Hello, A simple method for one such array is =IF(SEQUENCE(K8),J8) The problem is how to combine it with several rows. I would like to try usi...
Hello, See if you can find a solution from How to correct a #REF! error - Microsoft Support. In your scenario I would use Power Query to get the...
Hello, For the month you can use Date.AddMonths function, then you don't have to handle 13 as a month, it will be 1. = if Date.Day([Date]) > ...
Hello, In the blog post Personal Budget in Excel there is this note at the end of step 2. Note: in earlier versions of Excel you cannot use th...
Hello, Check this blog article about using Power Query Get Files from a Folder, see if that would work for your scenario. You can also check out th...
Hello, You get the data in correct format. Not sure if all columns are needed though. See attached file for two methods you can use. The PivotTa...
Hello Bradley, Great that it works as you want. As long as the structure is the same in all files, i.e. the number of rows and columns are the same...
Hello, I assume you want something like the attached file. It's just a quick fix solution that might work with your real data. In this example I...
Hello, You can use the ROUND or ROUNDUP functions, more about those functions in this blog article How to round numbers in Excel. Check attached fi...
Hello Frans, This is described in the blog article Excel Tables as Source for Data Validation Lists. Br, Anders
Hello, No file attached, but test if following conditional formula works. I assume you have Excel 2019 or newer. =MAXIFS($D:$D,$A:$A,$A2)=$D2 ...