View Single Post
  #3   Report Post  
bj
 
Posts: n/a
Default

check out auto filter
select column A
<data<Filter<Autofilter
click on the little arrow at the top of column A and select blanks
select the cells where the row numbers are colored and dlete the rows
turn off autofil

"Arlene" wrote:

or maybe with sort I don't know. All data in Column A several rows between
data. When I sort, all numbers go to top and names and ids drop to bottom.
How to maintain data integrity in the group and still delete the rows?
--
ALFR