jonas sværke

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

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 am currently comparing values in two sheets to each other to see if they are similar or dissimilar. I have this setup at the moment: My formula is: =IF(COUNTIFS('[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$T$2:$T$1712;E2;'[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$R$2:$R$1712;A2)=1;"yes";"no")...

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 this setup: My formulas in columns J-M look at their respective counterparts in columns D-G and once all four numbers have been entered in columns D, E, F and G, the cells in columns J-M will highlight which one has the lowest value. However, I would like to...

Hi all, I currently have this graph here: I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know: 1) is this possible, and if so, how? 2) if it is possible, is it also possible to make it do this coloring without pasting the orange...