Forum

All of the files must be in the same folder.

Yes, I agree that LAMBDAs could get out of control in the wrong hands!

Hi Saliha, I'm not sure I follow your question. Do you want a text string that joins together the different styles in column C? If so, you can use ...

Hi Henry, In Power Pivot you can set a 'Sort By' column rule in the modelling. This will force a PivotTable to sort any column by another numeric c...

Hi Mark, In Power Pivot you should create a date table. You can then add a column that classifies each date into the periods you want (your Output ...

Hi Jen, As long as you use the Get Files > From Folder path it doesn't matter if there's only one file in the folder. Just make sure that file i...

Hard coding it is just to narrow down where the issue lies and make sure it's not the file path itself.

Hi John, When you have an inactive relationship you can write measures that activate the relationship using the 'USERELATIONSHIP' function. If you'...

Hi Carolyn, Yes, you need a separate date table and you use the dates from the date table in your chart. Mynda

Hi Peter, I'm not following, sorry. The chart shows the previous 12 months. To me this is a history of 12 month's performance, so I'm not understan...

Hi Pieter, I'd write the query using Get Data > From File which will hard key the file path. Then edit the query and put the Mac file path in pl...

Hi David, Welcome to our forum! Can you please give us some context? e.g. where did you see this icon because it doesn't look like a modern Excel i...

Hi Pieter, As far as I'm aware, in Excel for Mac you cannot author queries, you can only refresh queries build in Excel for the PC, as explained he...

Hi Danielle, You can use INDEX & MATCH: =INDEX('RAW data'!E:E, MATCH(A2&"*"&D2,'RAW data'!C:C&'RAW data'!D:D,0)) Mynda

Hi Jacek, I think the problem with the example is that the data in the columns is the same as the column headers. It's also not clear whether you w...