ExcelBanter - Please Help and Thank you!

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Please Help and Thank you! (https://www.excelbanter.com/excel-worksheet-functions/45227-please-help-thank-you.html)

Arlene

Please Help and Thank you!

need to delete blank rows without using sort 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 blank rows?

--
ALFR

Ray A

one way:
highlight the rangeF5SpecialBlanks
then EditDeleteRows
HTH

"Arlene" wrote:

need to delete blank rows without using sort 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 blank rows?

--
ALFR

All times are GMT +1. The time now is 04:22 AM.