jonas edelhard sværke

Hi All, I have a debt of about 500.000 USD with an annual interest rate of 4.5% (quarterly added, so every 3rd month, the debt is increased by approximately 4.5% * 0.25 = 1.13%). Me and my friend are able to pay off debt at our own pace. I would like to setup an excel sheet, where I can...

Hi all, I have an overview that looks like this: Days since beginning / ended? Start date End date 01-10-2019 01-11-2023 01-10-2017 01-11-2025 01-10-2018 01-11-2028 01-10-2016 01-11-2021 01-10-2015 01-11-2018 And in Excel: I want to create a formula in column A that...

hi all, i have this overview: And in my other sheet entitled "XXX" i have this table: I am using this formula to calculate my nominal value in EUR: =IF(J2="EUR";I2;I2*VLOOKUP(J2;'XXX'!AO6:AS7;MATCH(J2;'XXX'!AO6:AS6;0);FALSE)) it should in the case above say 12046,37 * 0,134192, since...

Hi all, I have made a table and then gone to "Table Design" and "Insert Slicer". However, I have now updated my Slicer Column with new data and my slicer does not reflect this. How do I fix that? It clearly does not show "Established" and still shows the old "Received". How do I update it...

hi guys, i am SUPER bad at pivottables i have this dummy data for a loan here in my sheet: I essentially would like to create a slicer for "Status" that can filter for this table. However, in order to do so, it seems that I have to make a pivottable? I like my current formatting, but if I...

Hi all, I have an open workbook with three sheets called "1", "2", and "3". I want to hide these sheets and make it so that you cannot open or view them without a specific password. Right now, I can protect these sheets. However, protecting them means that you can still click on the sheets...

I dont understand why my taskbar here is so big i tried googling it, but nothing works also the taskbar is normal size on the other two monitors

Hi all, I have a lot of cells that look like this: Now, what I would like, is to have a formula that returns ONLY the top part of cell A3 I have separated the texts by pressing ALT + ENTER and then typing: Test 1 Test 2 Test 3 instead of Test 1 Test 2 Test 3 Is there a way in which I...

Hi all, I am trying to make a column of all the dates in September written in the format "dd-mm-yyyy": However, if I write "01-09-2022" and try to pull it down (as seen above), it just keeps posting "01-09-2022": Likewise, if I try to fill out more cells with "02-09-2022" and "03-09-2022"...

Hi all, I currently have the following setup: Is there an easy way to SUM this for each date? I realize that I can do something like this: However, I would like to make a solution in column C if possible or something along these lines, as the above solution would require me to make a new...

Hi all, I hope the title makes somewhat sense, but allow me to elaborate. I have a setup like this: I want my numbers in column D to replace whatever value is in column B However, if I mark all of column D and move it other to column B it will say the following: If I say yes to this, I...

Hi all, I currently have this setup: I would like to have column E automatically paste column D, but as values. Right now column D is filled with the formula (=A+B). I would like to have this pasted as values into column E, but done so on an automatic basis. The easiest solution I see would...

Hi all, I currently have this graph: I don't really care about the light and dark orange columns, but I need them to stay nonetheless. However, the grey chart rises from a value of about 9300 to 10500 doing this period, which is not that noticeable in this chart to be honest. I would like...

Hi all, I currently have a large data set, it looks like this: I want to vlookup my data from column A-C into column J-L. However, as the names reappear and sometimes even share the same date (example in A4:B5) a vlookup won't be feasible. The dates are correct in my other table, as well as...