I don't wish to sound patronising in any way but that is something I hadn't thought of, Mynda, using VSTACK() Append the headers to the FILTER() outpu...
There is a fairly easy to use solution to this problem. Create your worksheet as you have done so far and then add the column headers to your FILTE...
I understand the points you make John but I still wonder about that first line. As far as I can tell, the date in cell B2 is exactly the same date tha...
Adding the MODE.MULT() function using Ctr+Alt+Del will return the #N/A errors you found because that is what it was designed to do. It is telling you ...
There you are! Solved. Thanks, Catalin, I will be using that function from now on! Duncan
Thanks, Mynda. I have to confess that I did not go as far as changing any of the variables to test the thing fully so it's good to know that follow...
Thanks again, Catalin, I read the file more carefully this time and pasted my own folder path into the first sheet and it worked as you designed it...
Thanks Catalin I did take a look at your Get CSV function earlier but when I tried to get it to import all three csv files at once, it asked me to ...
Firstly, John, remove that first row in every testx.csv files because it is redundant as it seems the entry in row 2, column B relates to the date giv...
I hope you don't mind me chipping in, John. I took a look at your file and would like to offer the following If you want to show the formula you...
Try this, it worked for me! Sart by creating a 2D column chart with your data Right click on one of the bars ... Format Data Series Fill ... ...