View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

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