Hi

I'm aware you can't add, in Power Query, a formula that when closed/loaded/refreshed to excel runs automatically, but is there a way to add a column in Power Query with anything in it that is ignored by Power Query but forwards to Excel as text?

Eg, I need to add this formula, but PQ I think is seeing some of it and trying to action it. I just need the whole cells ignored and not run:
=IF(L2-"","",IF(COUNT(L$1:L$1,L2)>=1,"",L2))

I've tried adding a custom column and using = "=IF(L2-"","",IF(COUNT(L$1:L$1,L2)>=1,"",L2))" but all I get is an error. I can add plain text fine, but anything else errors.

Again I'm aware this likely will need dragged down the column, but that's a simple step.

thanks