Forum Discussion
Calculated Column using SEARCH
I have an Excel table with a column $P of comma-separated labels [@Labels]. The table is linked to an external data source I want to create a column which can be used for filtering, where I am l...
Hi. I don't get an error with ,0 in formula with direct cell reference (which is why I wrote it like that in my post), but I did work out that it does cause the error with column labels.
Mike Williams That's odd. I get an error with both methods. But happy you got it to work within a structured table.