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 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 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...
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...
datalogi advanced programming
excel & formula
ezsverkez svork
ez win 16-0
ez win guys
formula
gabe horn
haha ez win guys
help coding my conditions
jonas edelhard sværke
jonas sværke
jonas sværke advanced programming
jonas sværke ap
sumif
sumifs
svorktallica
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 am very rusty in Vlookup (embarassing!) and I am currently looking at this data:
I would like to create a formula that checks the same date in column A, as checked in column F and then tells me whether or not the value for this date is also present in my data set in columns F-G.
I...
christian røssel
code
excel
ezsverkezz
formula
help
hlookup
indexmatch
jonas sværke
jyggalag
macro
new blank workbook macro
record macro
sanoj ekrævs
sverk xd
sverkus derkus
svorkus dorkus
vba
vlookup
xlookup
Hi all,
I currently have a very messy sheet that looks like this:
Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have.
The issue is that my cells have become messed up, so for every...
christian røssel
code
comma
conditional formatting
delimeter
excel
excel &
ezsverkezz
formula
help
jonas sværke
macro
olzenmedz
record macro
sanoj ekrævs
sonaj jværke
sverktallica
svorktallica
text to collumns
text to columns
textjoin
vba
vlookup
Hi all,
This may seem super simple and silly to ask, but I have currently made this setup:
I have hidden EVERYTHING except for rows and column 1-7.
However, I would like to unhide row 8-10 now, but I have no idea how? When I click on "7", which is the closest row I can currently touch, and...
bongbong marcos
excel
ez 16-0 guys
ezsverkez svork
ez win 16-0
ezz
ezz svork
ezzus sverkus
formula
haha ez win guys
help
hide
index
indexmatch
jonas sværke
match
sanoj ekrævs
unhide
vba
vlookup
Hi all,
I have this very complex formula:
It returns a date value from a different sheet. However, it is returned in a number format, rather than a date format.
Any idea how to fix this? I believe that I can use the TEXT() formula, but I cannot figure out how :(
If anybody can help me...
date
easy
excel
ezsverkez svork
ezz
ezzus
ezzus sverkus
fast
formula
help
index
indexmatch
jonas sværke
match
sanoj ekrævs
sverksverkieboy
sverknation
sverktallica
svonkie
svorkie
svorkieboy
svorknation
svorktallica
svorkus
vba
Hi all,
I have the following formula:
The formula checks if the value in column D is located anywhere in sheet 2's values in the array B1:D133.
However, when I pull the formula down, it also checks blank cells. Is there any way to edit this formula, so when it checks a blank cell (for...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.