Yes it's possible.
At the last row + 1, double click on cell and just press Alt+Enter. So
this cell has only the line break nothing else.
Inlcude this row when setting the Data filer.
In filter chose Custom, and give following condition:-
Contains: -> Click on drop down and select the empty row (which will be
at the top and contains the line break)
And
Does not end with:-> Click the drop down and again selectg the same
empty row.
From the dropdown list in the column heading, choose Custom
From the first dropdown, choose Contains
In the text box, hold the Alt key, and on the number keypad,
type: 0010
Click OK
You're welcome. There's nothing similar for code. You could add a column
to the table, and use some of Chip Pearson's code for extracting colour
values. Then, filter on the new column.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.