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 the following setup:
I have some numbers in column C and D, and I use a simple sum() formula in column B.
However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime.
What I...
christian røssel
code
excel
ezzzzzzzzzzzz
fast
formula
goldstrome
help
hlookup
jonas sværke
lookup
minus
olzenmedz
plus 1
sum
sumproduct
vba
vlookup
xlookup
Hi all!
I currently have this setup, please note that I have hidden all the nonrelevant columns however:
The formula I use is this (thank you @RoryA !)
=IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...
&indexdd
code
column
copy
copy formula
copy paste
easy
fast
formula
formulas
help
hlookup
indexmatch
jonas sværke
madzi
madzi emil grell
olzenmedz
paste
vba
vba code
vba column letter
vlookup
xlookup
Hi all!
I have this setup (albeit much larger in reality):
Every statement has a sentence with "XYZ employees".
Is there a formula that can detect when a sentence says a number, followed by the string value "employees", and then return the value of the number? So that formula can fill out...
christian røssel
excel
ezzzzzzzzzzzz
formula
help
if formula
iferror
index
indexmatch
jonas sværke
jonassvaerke
match
olzenmedz
sanoj ekrævs
sonaj jværke
text
vlookup
vlookup text & values
Hi all,
I have the following setup (albeit in a much larger setting with multiple lines of emails):
I want to merge my emails in A121 and A122 into one cell, like I have done above in A120.
Is this possible? In reality, I need to do this for about 50-100 rows of emails from column B-T...
Hi all,
I have this formula I found online:
I have now set the formula to test if my value "test" in cell B2 is located anywhere at all in within the value set B1:D133 in sheet 2.
I literally have the value "test" in cell B2, but it does not work:
It should return the value "1" if the...
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 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 have this diagram:
However, the "above average", "average", "below average" etc. are really filling up a huge portion of the pie chart.
Can somebody please assist me in how I can hide them without removing them?
Thanks!
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...
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.