Forum

Hi Oscar, Please read the forum rules You don't need to click on the 'Quote' button, it just clutters up the thread and I delete the quoted te...

Hi Milly, How do you have duplicate columns? This article may help you Regards Phil

Hi Oscar, have you looked at the Conditional Formatting rules in my workbook? Home Tab -> Conditional Formatting -> Manage Rules Make s...

Hi Declan, If you can supply your workbook I'll try writing the necessary VBA. It shouldn't take too long as it'll be a modification of the code f...

Hi Oscar, You can't make words appear in a pivot table like that, but you can use conditional formatting to highlight negative months where the pre...

.

Hi Eva, You need to lay the data out in a tabular format with numeric values for the things you want to count. If you look at the attached file ...

Hi Manfred, I'm having trouble visualizing this without the data. Can you please supply your workbook with some sample data. Regards Phil

Hi Flor, You initial qs just said you were trying to look up one email address in another list on a separate sheet. How exactly does country play ...

Hi Alberto, You can add a Conditional Column and specify 0 for null and 1 for not null: then delete the date column. Regards Phil

Hi Flor, I don't fully understand what it is you are trying to achieve. But it looks like you're trying to check if an email exists in a column? ...

Hi mm, Thanks for the workbook but it's an XLSX so we'd still need to copy/paste your code from the forum into it to test it out 🙂 Please supply ...

Thanks Maurizio. Try the attached file. You will need to enter your own GMail email/password of course. Regards Phil

Hi Peter, You just need to wrap the HYPERLINKS in IFERROR because mousing over the link will generate an error. =IFERROR(HYPERLINK(dostuff(), "D...