Sort function filtering blank rows

[jpelletierfl]

I am attempting to use the sort function to provide me a 4000 row array in ascending order while not having the blanks show first.
Blank cells are ="". Some rows have cells with text and some cells are ""

How can I properly sort this?

=SORT(FILTER($A$2:$R$4000,$B$2:$B$4000<>""),2,1)

 

[Fluff]

Are you trying to sort on col B?

 

[jpelletierfl]

Yes sorting on column B

 

[Fluff]

In that case the formula should do exactly what you want.

 

[Beneindias]

Make sure you blank cells are actualy blank.

I had a problem with sorting values and it was because my cells werent actualy =""

 

[jpelletierfl]

It returns an #N/A error upon running

 

[Fluff]

In that case check that you don't have any #N/A errors in the data.

 

[jpelletierfl]

found one in a hidden row - thank you for your help!

 

[Fluff]

You're welcome & thanks for the feedback.