Forum Discussion
filter by strikethrough
I want to filter an Excel file, showing those cells that contain strikethrough text. I cannot find a way to do this, even in Advanced. How should I do it? Excel Professional Plus 2013 (32 bit), W...
So GET.CELL does what it says on the tin; it gets the properties form a single cell only. I tried giving it the entire column from the table as the reference but the function only returned a single value so it was no use for the FILTER function.
A hidden helper column in the Table did the trick though.
Hi Peter - yes, that's with helper column.