Last seen: May 22, 2025
Use: strbody = "<font size=""3"" face=""Calibri"">" & _ "Hi Lawrie,<br><br>" & _ ...
That one works fine for me (other than the missing Value column).
The data in the second workbook doesn't have the same headers in row1, which means that your query to load the data doesn't produce the same headers a...
Instead of using 1/07/20 try using #date(2020,7,1) and similarly for the other date literals.
+ would be the equivalent of an OR criteria operator, whereas * is the equivalent of AND.
Couldn't you just add another criterion to the MINIFS that the date in B has to be >1?
For E2: =SUMPRODUCT(('WK1 DATA'!$D$2:$D$12=A2)*('WK1 DATA'!$H$2:$H$12="Y")) and copy down. Then for E15: =SUMPRODUCT(('WK1 DATA'!$N$2:$N$12=A...
I'd probably start by clearing the cache in your Query Options. If that doesn't help, try copying the source file locally and linking to that to see i...
Save it as a tab delimited text file, then change the extension if necessary (though a CSV is, by definition, comma-separated).
Probably a stupid question, but, just to check, you are talking about the data being wrong in the actual query results, not just in the preview window...
I'm assuming there is more to this question because if you want all the rows and all the columns, you don't need INDEX at all: just use =C3:G14
You need an array for the columns too, so you could use another SEQUENCE function.
The GETPIVOTDATA formula works if you use the Hours Formula field in the pivot. I'm not really sure what the issue was with that?
There are several ways you could achieve it. For instance, you could create one query on the table that filters for topology, then merge that query wi...
How would you distinguish a header row from a data row specifically?