Forum

Hi Bob, The direction of your relationship was the wrong way around. Table 2 should lookup Table 1. Delete the relationship and in the diagram view...

Hi Gejza, In your query go back to the 'Source' step and click on the gear icon. In the dialog box under the File Origin choose 1252: Western Europ...

Hi Valerie, I don't understand your question "how do I get the Sep filter next to the date?". Can you please show me, either with a screen shot or ...

Hi Tim, I agree with Sunny. Here are some tutorials on our site for the SUBTOTAL Function and AGGREGATE Function. Note: AGGREGATE was new in Excel ...

Hi Valerie, In the Excel file for session 5 the 'Menu' sheet has a hyperlink button to the lesson TOC for session 5.09 (the 5.09 TOC sheet is call...

Hi Michelle, It's hard to say. If you're just importing a text file then the whole file should come in as is. Are you trying to merge that text fil...

It's great to see the forum was able to find an answer to Shelley's question and it's wonderful to see an active discussion with many participants all...

Hi Greg, I'd use Excel Survey to collect your data. You can add columns to the table created by Excel survey and add your formulas in there. Otherw...

Thanks for sharing your solution, Henk. Another one I've not seen before. My only concern is that the lists would be difficult to maintain. I suppo...

"The numerator of the EDWIN is the sum of the Emergency Severity Index triage categories (ti) of all active patients (ni) in the ED." Good point, Cata...

Thanks for sharing that solution, Paula. It's very clever indeed. Mynda

Actuallly, my bad. The formula should have been: =(A2*A3)/A4*(A5-A6) I incorrectly used divide instead of multiply after A4. It gives the sam...

You're welcome. I look forward to having you join my Power Query course. I'm sure you'll love Power Query and wonder how you lived with out it 🙂 ...

Hi Shelley, Please find file attached. Not sure if the values I substituted into the formula make sense but you can replace them with real figures....

Hi Valerie, On the Leads Data sheet in cells Y59:AE68 you'll see there are formulas that divide the values in the marketing cost PivotTable by the ...