| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I delete multiple blank rows collectively? | Excel Worksheet Functions | |||
| Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
| select and delete all blank rows | Excel Discussion (Misc queries) | |||
| How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
| How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) | |||
Hybrid Mode
