jonas sværke

Hi all, Thanks to some of your great earlier contributions I was able to set up with this formula: =IFERROR(LET(mpos;MATCH(1E+100;G7:K7); mval;INDEX(G7:K7;mpos); IF(mval>V7; RIGHT(INDEX($G$3:$K$3;mpos);2) & " TPC is bigger than TPC MEC by " & TEXT(ROUND(mval-V7;0);"#.##0") & " USD"; ""));"")...

Hi all, I am calculating depreciations like this: However, my formula ONLY calculates depreciation for january if the date in column B = 01-01-2024. Is there any way to change it, so it calculates this as long as the date in column B is in the same month as in the date mentioned in column F...

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 this formula: Formula: =IF(J4=""; IF(I4>P4; "G4 grant bigger than Total grant (IA) by " & TEXT(ROUND(I4-P4; 2); "0.00") & " DKK"; ""); IF(J4>P4; "G5 grant bigger than Total grant (IA) by " & TEXT(ROUND(J4-P4; 2); "0.00") & " DKK"; "")) I want to expand it, so that it looks my...

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 this formula: =IFERROR(SUM(IF(FREQUENCY(IF($A$2:$A$101=A2;IF($D$2:$D$101=D2;IF($H$2:$H$101=H2;MATCH($I$2:$I$101;$I$2:$I$101;0))));ROW($A$2:$A$101)-ROW($A$2)+1);1));"0") It checks the following sheet (please note that A2, A3 and A4 have the same value): ' I want the formula to...

hi all, i have this setup: I want to count every cell that has a numeric value for Zimbabwe, USA and the UK How do I do that? I want it to discard the other cells such as "N/A", "-" or blank cells and only count the numeric ones with values and then return to me the number of cells...

I have a sheet called "Number of bank accounts". Here, in row 5, I have listed "Denmark" in cell C8, "Sweden" in cell C5, "Norway" in cell D8 and so on. In the respective cells underneath this, I want to have a formula that can take the name of the cell above it and look up the country above it...

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 have a VERY LARGE sheet like this: All the numbers are "text" for some reason?? I want them to be numbers, but I have to manually click each cell and press "Convert to Number" How can I do this faster for an entire column from B2:B5000? Thanks! Jyggalag

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 currently have this: I want to hlookup the value in my other table based on the date in column A (01-06-2022) It should return the value here: However, I do not know how to get it to return the value of 175937,93? I tried to put in "955" as the column index number... but it...

Hi all, I have this setup at the moment: However, when I search for "14-06-2022" I get a sum of 9964136,14 because my SUM formula takes all the hidden rows into account When I plus all the numbers I get the correct amount of 372344,76 But it takes a lot of time to write "A1 + A101 + A102 +...

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...