how can you sort a list to delete blank rows ?
 

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?

how can you sort a list to delete blank rows ?
 

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.
--
Gary's Student


"Irishimp23" wrote:

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?

how can you sort a list to delete blank rows ?
 

Thank you so much... it really helped!

"Gary''s Student" wrote:

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.
--
Gary's Student


"Irishimp23" wrote:

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?

how can you sort a list to delete blank rows ?
 

You are very welcome
--
Gary's Student


"Irishimp23" wrote:

Thank you so much... it really helped!

"Gary''s Student" wrote:

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.
--
Gary's Student


"Irishimp23" wrote:

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?