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...
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 !)
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...
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...
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? :)
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