how can you sort a list to delete blank rows ?

I

Irishimp23

I have a list of employees in column A. In the columns following the names I
have x's in the appropriate options for them. Some of the rows do not contain
any x's and I would like to sort them where they are at the bottom ...so that
all of the names with the x's are grouped together. Any suggestions?
 
G

Gary''s Student

Use a helper column and sort:

Let's say your x's are in columns B thru F, then in column G enter:

=IF(COUNTA(B1:F1)=0,0,1)

and copy down. Sort by column G descending.
 
I

Irishimp23

Thank you so much... it really helped!

Gary''s Student said:
Use a helper column and sort:

Let's say your x's are in columns B thru F, then in column G enter:

=IF(COUNTA(B1:F1)=0,0,1)

and copy down. Sort by column G descending.
Click to expand...
 
Top