Last seen: Jun 22, 2026
Hi Christina, Welcome to our forum! Thanks for sharing your file. It's great to see you're using dynamic arrays 🙂 The difficulty you're havin...
Hi Santosh, Is the query connected to data in another Excel file? If so, is that Excel file open when you try to refresh the query? I ask because t...
Hi Akhil, Welcome to our forum! It's difficult to help without seeing your data. The error is caused by text in a column that should only contai...
Hi Weston, Welcome to our forum! Have you tried doing anything else with the model e.g. insert a PivotTable, create relationships etc. I'm trying t...
Hi Claudine, Thanks for sharing the file. Unless there is some logic that can be applied to the Team names in order to derive the sort order, then ...
Hi Henrik, I can't reproduce that error. The formula returns 3 for me. Do you get the same error with: =COLUMNS({1,2,3}) OR =COLUMNS({0...
Yes, you add rules. Start with the negative values: if value is greater than or equal to, -99999999, Number and less than 0, number is red. Then add a...
Hi Ronald, I'm confused, you said " I would like the second item in J5 'SS' in a cell and in the cell next to it 258.24. Is this possible?". That...
Hi Erik, Welcome to our forum! These date names are system generated based on your locale settings on your PC and Excel. If you want them to sho...
Hi Claudine, I feel like I only have half of the information. If you're merging the tables, then there must be a common column other than the sort ...
Hi Aye, You need to use conditional formatting to apply red fonts for negative values. Mynda
Hi Ronald, I'm not sure I fully understood as there wasn't a 'desired result' example in your file, but I've had a go at what I though you meant. Y...
It depends how you're determining the sort order. Is it something that can be done with 'add a custom column' or an index column?
Hi Claudine, I'm not sure what you mean, but if you right-click the query name in the Query editor you can choose to duplicate the query. Mynda
Yes, you'd have to add empty cells to your source data to create the space in the chart.