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 data set that looks like this:
The issue for me is that it is currently stated in a format of "Month-Date-Year". I would like to replace this with a format of "Date-Month-Year".
Does anybody have a nice solution to this, for example a formula as illustrated in my...
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
ezz
ezzzzzzzzzzzz
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
Hi all,
I currently have this VBA code:
Option Explicit
Private Const FilePath As String = "S:\COMPANY\FOLDER OF COMPANY\FOLDER 15\TEST FOLDER\Attachments\"
Sub send_email_complete()
Dim OutApp As Object
Dim OutMail As Object
Dim i As Long
Dim ws As Worksheet
Dim col As...
christian røssel
code
easy
fast
help
hlookup
htmlbody
index
indexmatch
jyggalag
match
olzenmedz
pdf
røssel
røssele
sanoj ekrævs
save excel
save pdf
vba
vlookup
xlookup
xlxm
xlxs
Hi all,
I currently have this setup:
My VBA code is this ( credits to @RoryA :) )
Option Explicit
Private Const FilePath As String = "\\UBSPROD.MSAD.UBS.NET\userdata\t684895\home\Documents\faq folder\"
Sub send_email_complete()
Dim OutApp As Object
Dim OutMail As Object
Dim i...
Hi all,
I have this amazing email macro that @RoryA helped me build (big credits!).
He created a nice loop for me that runs all subjects in an email meaning I can email as many email addresses as I want at a time.
However, when I run it now, it converts my text into numbers for some reason...
Hi all,
I currently have this code:
Option Explicit
Private Const FilePath As String = "\\COMPANY.MTJG.COMPANY.NET\userdata\t6853532895\home\Documents\TEST folder\"
Sub send_email_complete()
Dim OutApp As Object
Dim OutMail As Object
Dim i As Long
Dim ws As Worksheet
Dim...
Hi all,
I currently have a data overview that draws data through power query from a folder in my windows computer:
However, I plan to update this folder rapidly every week and I was wondering if it would be possible to create two macros attached to VBA codes, where they do the following:
1)...
Hi all,
I have this file:
How do I make a conditional formatting formula (or whatever it takes) so if the COLOR (not the text!), but the color in column C is red, then the color for the respective cell ("hello" and "this" in cell A1 and A3) will also turn red?
Hope my question makes sense...
Hi all,
I am having a huge issue at the moment with some macros i created (through record macro).
Basically, I have this excel sheet:
I tried to record some macro's, where once I press unfreeze, they post this formula:
=IF(ISBLANK(B9),"",TODAY()) for the left one...
code
coding
copy paste
copy paste as values
excel
formula
help
iferror
index
indexmatch
jyggalag
macro
match
olzenmedz
record macro
today function
today()
vba
vlookup
yonasreppenk
Hi all,
I am currently facing a weird issue in PowerPoint.
When I type text, the border disappears underneath it:
It is specifically happening in the cell where it says "test" in bold.
Any idea why this is happening? I've looked at my formatting, but cant quite figure out why.
Kind...
Hi all,
I currently have the following setup:
I have marked everything that I want to be exported into a PDF, which works when I manually save the file as a PDF.
However, I do also have a macro ("Save file to folder") as seen above, which saves the file (albeit as an Excel file) to my...
Hi all,
I currently have a bunch of files that are 99% similar, except they have some different data in their columns. The first two rows will always look like this:
Unfortunately, the first row messes with the power query, so it returns this:
If I remove the first row, my file works such...
code
conditional formatting
easy
excel
fast
formula
help
indexmatch
jyggalag
macro
pivot table 365
power cable
power query from folder
svorkieboy
vba
vlookup
Hi all,
I currently have the following table:
Is it possible to make it so cell A3 has the same color fill as cell A2 (light blue) until it reaches "Week:" where it would then have a yellow fill?
Thank you! :)
Hi all,
I am currently using this formula:
With its neighbor formula in column C going like this:
My question is whether it would be possible to somehow freeze my data in cell B3, C3 etc. going forward? So once the formula detects that a data entry has been in the cell 2 rows below it, it...
Hi all,
I currently have this setup:
I have a row of formulas saying IF(ISBLANK(cell below),return blank value, otherwise return value to the left + 7) to advance the week one week ahead when data is entered.
I want to create a conditional formatting for this row, so whenever a value is...
Hi all,
I have a table that looks like this:
Whenever I try to remove the borders, I am left with 2 possibilities: Either the border is removed and I am left with a white border (rather than a full green box) where the old border was, or (most common) the cells are merged into one big green...
Hi all,
I would like to create a macro where, once I press it, it saves my file to my folder \\COMPANY.MDDD.COMPANY.NET\userdata\t654895\home\Documents\test files
Does anybody know how I would go about in doing this? :)
Thank you!
BR.
Jyggalag
Prince of Order est. March 26, 2007.
Hi all!
I have this formula:
But for some reason, my formula does not work? I want my formula to return "NOT BLANK AND NOT 1" if the cell contains a value that is not = 1 and not a blank cell. If the cell contains the value 1 or is blank, i want my formula to return a blank cell.
Can...
Hi All,
I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one.
In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...
code
data source
excel
formula
formulas
help
iferror
indexmatch
jyggalag
lookup
pivot table
pivottable
power
power bi
query
source
svaerke
vba
vlookup
xlookup
yonasreppenk
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.