goldstrome

  1. Jyggalag

    Why is my vlookup + MATCH formula not working?

    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...
    • Jyggalag
    • Thread
    • excel ezz formula goldstrome index jonas edelhard sværke jonas sværke match svorktallica vlookup
    • Replies: 6
    • Forum: Excel Questions
  2. Jyggalag

    How to do LEFT/RIGHT/some other formula to return only top part of text from a box?

    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...
    • Jyggalag
    • Thread
    • easy excel formula formula =and() goldstrome help jonas edelhard sværke jonas sværke left right
    • Replies: 5
    • Forum: Excel Questions
  3. Jyggalag

    Excel won't let me pull down dates to automatically fill out cells?

    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"...
    • Jyggalag
    • Thread
    • date df lover excel formula goldstrome jonas edelhard sværke jonas sværke jonas sværke goldstrome pull down
    • Replies: 1
    • Forum: Excel Questions
  4. Jyggalag

    Edit formula so it returns blank value? Not working for some reason right now

    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...
    • Jyggalag
    • Thread
    • easy excel ezz ezzus 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
    • Replies: 4
    • Forum: Excel Questions
  5. Jyggalag

    Make VBA code that posts a cells formula as a value

    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...
    • Jyggalag
    • Thread
    • christian røssel code excel ezzzzzzzzzzzz fast formula goldstrome help hlookup jonas sværke lookup minus olzenmedz plus 1 sum sumproduct vba vlookup xlookup
    • Replies: 1
    • Forum: Excel Questions
  6. Jyggalag

    Email macro

    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...
    • Jyggalag
    • Thread
    • code goldstrome help htmlbody iferror index indexmatch jyggalag macro match olzenmedz quizzerolzen quizzzz vba vlookup yonasreppenk
    • Replies: 10
    • Forum: Excel Questions
  7. Jyggalag

    Use macro to delete files from folder?

    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)...
    • Jyggalag
    • Thread
    • delete delete file easy excel fast folder goldstrome help hlookup index indexmatch jonassvaerke jyggalag macro match olzen olzenmedz sverk sverknation svorkieboy svorknation vba vlookup xlookup yonasreppenk
    • Replies: 2
    • Forum: Excel Questions
  8. Jyggalag

    Conditional formatting for blank cells containing formulas?

    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...
    • Jyggalag
    • Thread
    • conditional formatting excel formuals formula formulas goldstrome help if statement ifblank iferror indexmatch isblank jyggalag vlookup yonasreppenk
    • Replies: 8
    • Forum: Excel Questions

We've detected that you are using an adblocker.

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.
Go back
Back
Top