I'm not quite sure what you mean. Do you want to show the rows where the value
in column A begins with a letter (or column A is empty)?
You could use a column of helper cells with formulas like:
=OR(AND(CODE(UPPER(A2&"A"))<=90,CODE(UPPER(A2&"A") )=65))
Then filter to show only the Trues.
D Hafer - TFE wrote:
What would I put into an autofilter parameter to show only rows which begin
with text or are blank?
--
Dave Peterson
|