Forum

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...

Hi Cindy, Where does the raw data come from? You say a file, so it's not in Excel to start with? What generates the file? Is it always in this...

Hi Marsil, Please see the attached file which is based on some code from I can't really test this for you as I am not connected to your Exchang...

Hi Stephan, You could wrap the function that produces a 0 in an IF and display an empty string =IF(MIN(IF(A7<=$BG$2,IF(AL7:AO7>0,AL7:AO7,"...

Hi Mido, Welcome to the forum. On the face of it this looks like something I can help with but I'm missing some important information. Please...

Hi Amar, Yes Power Query is a fantastic tool but for this problem you don't need to use it. You can achieve what you want with functions : =IFE...

Hi Nicole, You could try the attached code which works for the 4 sections you currently have in the document. If the maximum number of tables unde...

Hi, I took your source data table and copied it to another sheet called New Data. I removed blank columns. In the source data table I added a new...