Last seen: Apr 29, 2025
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 ...
Hello, Sorry, here comes the updated copy. Br, Anders
Hello, With the help by Hans’s and Riny’s comments I did some changes and now got the wanted result. Hopefully it works with the real data too. ...
Hello, I am not sure I understod this correct, I have followed the instructions but am far off from your wanted value. Do check if this is usable o...
Hello, You can use =SUM(COUNTIF(A1:A17,B1:B17)) to sum the duplicates found in column B. Br, Anders
Hello, In your sample data you have no T1 discount factor below 12, that is why you get the #DIV/0! error. You can use IF or IFERROR to handle such...
Hello, Check out the blog article Dynamic Dependent Data Validation to see one way to get what you want. If you need hands on help, please uploade ...
Hello, The closest you get (as far as I know) is to use CTRL + [ to go to precedent cell or CTRL + ] for dependent cell. The shortcuts are for thos...