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 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 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 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 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...
Hi all,
I currently have a data set that looks like this:
I would like to transpose my information down under columns H-L so that for ALL cells in A that contains "George", their respective cells in columns B-F will be transposed under column H.
Likewise the same for all cells that contain...
Hi all,
I have this file that was converted from PDF to Excel.
I would really like to filter everything in column A by date
However, when I do it looks like this:
It filters down until row 687
The row looks like this:
I have no idea why it stops?
It used to stop at points like these...
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
ez sverk
ezz
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 &
ez sverk
ezz
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,
I currently have a macro that converts my excel sheet into a PDF and saves it in a designated folder. However, I only want it to save the first sheet as a PDF, and ignore my other sheets, which it will not do at the moment.
My code looks as follows:
Option Explicit
Sub...
code
excel
ez win 16-0
ezzezzus sverkus
fast
haha ez win guys
help
jonas svaerke
macro
pdf
roessel
sanoj ekrævs
save as pdf
svorktallica
vba
vba code
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
ez sverk
ez svork
ez win 16-0
ezzezz 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 formula:
It pulls in data from here:
However,
despite this column being completely empty, it returns the value 0, rather than a blank cell as I have commanded it to.
I have checked the cells in column H and there are nothing there, not even a space, so i do not...
easy
excel
ezzezzus
ezzus sverkus
fast
formula
goldstrome
help
index
indexmatch
jonas sværke
match
p90 jonas svaerke
p90 rush svork
p90 svork
p90 svorkrush
sanoj ekrævs
svorkieboy
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
ez sverk
ez svork
ezzezzus
ezzus sverkus
fast
formula
help
index
indexmatch
jonas sværke
match
sanoj ekrævs
sverk
sverkieboy
sverknation
sverktallica
svonkie
svorkie
svorkieboy
svorknation
svorktallica
svorkus
vba
Hi all,
I currently have a list that looks like this (albeit much much much larger in reality):
I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...
christian røssel
conditional formatting
easy
excel
ezzezzzzzzzzzzzz
fast
format
formula
help
hlookup
index
indexmatch
jonas sværke
jyggalag
match
peter lim
pivot table
slicer
sverk
sverkieboy
sverknation
svorkieboy
svorknation
svorkster
svorktallica
vba
vba & code
vlookup
xlookup
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.