I currently have a large worksheet that is similar to this:
With the master data looking like this:
I want to create a sort of IFERROR(IF(INDEX=0, ,MATCH and MATCH formula (with an iferror that returns "" (blank) if there's an error)) for every column with  such as [DATE].
I currently have something similar to this:
Linking to this:
It should return the date 21-06-2019 for XG10, but it does not.
Can anybody see what I did wrong and how to fix it?
Would be greatly appreciated! :)
I currently have a large list of data, but to simplify, here's a simple example:
I currently wrote cell C5 as = J5
I then pulled it through the green box as you see in the photo to the right and got A, B, C, D and E and pulled it down and got 1, 2, 3, 4, 5
However, I want it to...
I am completely, absolutely 100% new at Power BI. This is my first official day, so please bear with me :)
I currently have the following Dashboard:
Now, if I insert an image I can get it it to fill all of the screen except for below the dotted line (my red arrow is pointing at...
I currently have an excel sheet that looks similar to this (but much larger):
And then a master data sheet next to it that looks like this:
Please note that some of the titles are not in the master data set (in reality however, they all are, i just created this example...
Whenever I open a PowerPoint document, the function "Embed fonts in the file" is turned off:
Is there any way in which I can make it so this is automatically turned on?
Thank you! :)
I am currently looking at excel/PowerPoint, where you have the following when you open a document:
In the cases above, I have simply opened a blank document. However, what annoys me is that if I use a template from any prior documents, it will say the names of the authors...
It's nice to be back on the MrExcel forum :)
I am currently managing a list that essentially looks like this (just a lot bigger):
I would like to create a pivot table and a slicer for this (the real file is over 1000 cells) so it becomes much easier to look up specific...
Please note that I made an earlier thread and am now continuing with the same sheets as before, but also including a new file (file 3). The old thread is here: Excel vlookup problems
I currently have three files, file (1):
And file 3:
Currently, file 3 has the...
I am relatively new to Excel and have little experience with functions, especially across different excel files.
I currently have two excel-files, where one looks like this (file 1):
And the other one looks like this (file 2):
Currently, what I would like is for file 1 to...
NOTE* Please skip until the next line highlighted in bold if you're not interested in seeing how my setup functions. Thank you!
I am currently managing a minor inventory consisting of 101 unique goods. Currently my excel sheet looks like this:
To briefly explain the sheet...
I have stock on column G and minimum stock on column F. I want to highlight my stock if it is below the minimum stock through conditional formatting:
As you can see, I have made the correct conditional formatting that if my value is equal to or less than F2...
I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so:
Column I = Current quantity
Column J = Enter any...
I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2).
Currently, I have just set the fields in my "Order form" sheet = the...
Hello Mr. Excel Community
Since 5 hours I am struggling with the following code, which I'd love to expand.
I simply want to mimic the built in ctrl + F search tool via an Input Box, adding the feature to stay in row/column (ActiveCell) while looking for the name (letters not numbers).
Hello, like i said probably an easy thing to do but im not able to search properly for what I want to do, basically I would like to take a current total, and add to it when another cell total changes, except i already am seeing errors in what i want to do. So i think i want a macro so after all...
I want to loop through an array looking for the below values. IF it finds them, I want to change the value, if it doesn't, just move on.
10 Very Easy
10 Demonstrated Well
10 Very Satisfied
1 Not Demonstrated
1 Not Satisfied
1 Not Easy...
I am trying to find the best and easiest way to calculate age. I thought it is something easy but it turn it is a bit complex. The websites below showing how to calculate age. But I only found Excel-Easy.com is better and easier yet it is not that easy because they use a function called...
This should be a really easy question for you VBA experts. I have the following code:
What I would like to do is have one line code that does the above but then keep the selection but one cell below the full range. For example, if the code above...