Hi all,
I currently have this graph:
I don't really care about the light and dark orange columns, but I need them to stay nonetheless.
However, the grey chart rises from a value of about 9300 to 10500 doing this period, which is not that noticeable in this chart to be honest. I would like...
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 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 sheet that looks like this:
(Please note that I have divided my excel file into two windows, so you can see both sheets at the same time).
I have created a pivot table (very new to this!) in Sheet2 where I can store the data. I expect, from now on, to download my...
Dear all,
I feel like most IndexMatch tutorials are very complicated.
Does anybody have a good link or video that explains this formula, preferably with an iferror in front as well, understandable for a tech newbie like me? :)
Thanks!
I have tried to combine the text with an array formula, but can't get it right
="The Sales Report as at "&B1 "&INDEX(D:D,MATCH(1,SEARCH("*grand*",A:A)))
It would be appreciated if someone could assist me
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.