Forum

Hi Frans, If you've deleted some data from the source, that data can still be displayed unless you tell the PT / Slicer not to display it, even if ...

You're welcome 🙂

Hi Wansley, You have code in the workbook which is not mine: Private Sub Workbook_Open() If GetCodeSetting("CodeSetting") = False Then Exi...

Hi David, I'm not sure that the data is misleading, the values are what they are. When your wife asks for the numbers to be 'closer together' what ...

So if you are overwriting the data every time you take a report from SAP, there is no way to know what emails have been sent, with the current code. ...

Hi JP, Power Query isn't really the tool for this. This is an optimization problem you should do in Excel. It's not clear if this is a one off ...

Hi Mido, The code will send an email when the value in Col E is >= 180. When an email is sent the code will enter the date the email was sent...

No worries Marsil. To get the email address for the sender change Range("A1").Offset(i, 0).Value = Email.SenderName to Range("A1").Offset(...

Hi Mido, The attached file will send emails based on the criteria you stated. There needs to be some way for the code to be started so it is pla...

You're welcome. Phil

Hi Bunmi, You can check the type of a value using Value.Type like so if Value.Type() = type number then Text.End(Text.From(),5) else Text.Start(...

Hi Ashley, As the email address is being found, XLOOKUP will return something, so specifying "" for if_not_found is not applicable in such cases as...

Hi Cindy, Sounds like your BI dept are causing you a lot of headaches 🙁 Sorry to ask more questions but the key here is to get raw data in a st...

Hi Ashley, On row 2 you are looking up [email protected] and this is found in ColA of the Opt Outs sheet. So XLOOKUP is returning what it finds in the c...

Hi Allyn, You could force a Treemap to do something resembling what you want, but it's temperamental and not really designed for this. The other...