Forum

Good job. Thanks for letting us know.

Hi Sholtan, Please post the solution so that others may learn. regards Phil

no worries 🙂

Hi David, Yes they can. In fact you really need to know Power Query and Power Pivot to get the most out of Power BI. You can find out more from...

Hi Stephan, The answers are: 1. Complete the IF statement by providing an answer if false, which is just an empty string "", so in C7 =IF(A7&...

Hi Moutaz, The best layout is a tabular format where there is a column for every type of data or 'thing to be measured' and a row for each record o...

Hi Stephan, You can use INDIRECT to reference the year in Column A, for example in D6 you could have =INDIRECT(TEXT(A6,"yyyy")&"!$V$32") ...

Hi Adam, Please see attached and compare to your solution. After unpivoting the date columns, I've grouped by Country and Date to give the final...

No worries Pat. Learning VBA can put years on you 🙂

Hi Marsil, That is a Microsoft Exchange user. Are you connected to Exchange? Phil

Hi Pat, There's a few things there that need fixing up. You have an IF statement with lots of OR conditions and these conditions are carried ove...

Hi David, You check from the account setup in Outlook. It'll depend on your version of Outlook but it'll be something like File -> Account Sett...

Hi Steve, In Private Sub Arow5_Change() you can use Me.Arow6.Value = Arow5.List(Arow5.Value, 1) Regards Phil

Hi David, There seems to be some confusion which isn't helped by you not answering my questions. The code I've written is to read emails from a ...

Hi Marsil, Try this. regards Phil