![]() ![]() When I turned FILTER on again and selected for "1", only the Title rows appeared. (Those rows happened to be "Title" rows for clumps of data below them.) It read =COUNTA(A1) and copied IT down the D column to the end. ![]() That was so easy, I then got fancy and changed the COUNTA function to only select items from the A column that had data in them. When I turned OFF the filter, I had a perfect set of cleaned data. Then I clicked and dragged down the left-side ROW NUMBERS (those in the margin) to select those rows, right-clicked and selected DELETE. ONLY the totally blank rows had been selected! The result was a sheet of empty cells with 0s in column D. Then I used the FILTER command on Column D to only show the rows that equalled 0. So, my D column had a stack of 3s,2s,1s & 0s. The formula went =COUNTA(A1:C1) and then copied it down thru several thousand rows of data. I created a fourth column in which I used the COUNTA function. The PROBLEM was that selecting BLANK cells would DELETE ENTIRE ROWS that had data in other columns. ![]() ![]() Only SOME of the rows (1,242 in this case) were blank all the way across. Sometimes a row in column two was blank, but the cell beside it in column three had data. The remaining two columns had random data at various rows all the way down. The first column had title lines every five or six rows. "Blank rows deletion" is awkward by most methods. Easy deploying in your enterprise or organization. Combine Workbooks and WorkSheets Merge Tables based on key columns Split Data into Multiple Sheets Batch Convert xls, xlsx and PDF.ģ00 powerful features.Super Filter (save and apply filter schemes to other sheets) Advanced Sort by month/week/day, frequency and more Special Filter by bold, italic.Extract Text, Add Text, Remove by Position, Remove Space Create and Print Paging Subtotals Convert Between Cells Content and Comments.Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |