Forum

Hi Alicia, From what you describe above, you're on the right track. However, you shouldn't be splitting the transaction data up into separate queri...

My bad, Mohamad. I misread your question...it was early! You can copy cells in Excel and then go to Word and right-click > paste as link. By def...

Hi James, Glad we could help. Yes, please start a new post with this question. I will be away for the rest of the week, so don't address it to me s...

Hi Mohamed, If you insert these descriptions in the Excel cell Comments/Notes, you can print them (to PDF) by selecting the setting in the Page Set...

Hi Jennifer, I think you need to add another column to your Youth Age table that converts their age based on the first incident of the month. You c...

Hi Kevin, You can use this formula: =INDEX(T,COLUMNS($A:A),COLUMNS($A:A)) Mynda

Hi Robert, Welcome to our forum! It's tricky without an example file. If you have a Microsoft 365 license, you can use this formula: =FILTER(...

Hi Valerie, Great to hear you're making progress. Well done! It's very difficult to visualise all this information and help without seeing your ...

Hi Mattias, You can get import the climate zones using the csv, Excel, JSON or PDF file types on the ggis.un site. As for the issues you're expe...

Hi Anita, I've moved this question to the Excel Expert course members forum so that it gets answered promptly. Can you please upload a sample of yo...

Hi David, You're on the right track. If you prefer to have actuals, you'll need to remove the duplicate data on 23rd August at 6:23PM, 8:30PM, 9...

Hi David, Welcome to our forum! Yes, you can structure your data into a 3 column table. Use a PivotTable to summarise the data by date and time ...

My bad, I should have said Append, not Merge. No need to get files from folder, just get each CSV file using Get Data > From Text/CSV. See attache...

Hi Jim, File 2022-After_School_(in-person)2022-09-02_19_34_34.csv only has 37 columns. The second child names in 2022_Fall_Online_Classes2022-09-02...

Hi Kevin, Welcome to our forum! Please see this tutorial on displaying the grand total in a Pivot Chart. Mynda