Ignoring Blanks with Advanced Filter

[rgs694]

Hello,
I've been searching a lot on the web to find help with this, but all the answers have been varied and I've not been able to get any to work. I have a single column containing text that I want to use advanced filter to 'copy to another location'. I need to ignore blanks and keep unique records only. Each cell in the column contains mostly numbers, but all have a leading letter. My list range, criteria range, and copy to range all have the same header, and are set up like this:

A (list column) C (criteria column) E (copy to column)
Account Number Account Number Account Number
R568415 ? criteria ?
R568415

R958745
R958745

R748748
R748748

What criteria to I place in C2 (C1:C2 = advance filter criteria) in order to copy and filter the data in column A, and paste it into column E as follows:
E (copy to column)
R568415
R958745
R748748


Based on the various criteria I place in C2, I either copy nothing into column E, or I get this:
E (copy to column)
R568415

R958745
R748748


There is an empty cell after the first Account Number, which represents the one unique space leftover from the original list in column A. This causes problems with other things I'm doing with the data after copying and filtering. Btw, I've tested the blank cells in column A with an Isblank formula to verify that they were in fact blank.

Thank you,
-Rich
Excel 2013
Intermediate Experience

 

[RoryA]

Put an asterisk in C2.

 

[chicagocomputerclasses]

you can use this as a criteria and make sure you check to get unique values only

Account
>""

<tbody>
</tbody>

 

[rgs694]

Perfect. Thank you both!
-R