Google Sheets – How to Sort by Number of Empty Cells per Row

formulasgoogle sheets

In my sheet, there are 5 columns of data. Some rows are fully filled and some rows have some empty cells. Now I want to sort my sheet from most-filled row to least-filled row. How can I do it?

Best Answer

Simply use =COUNTA(range) in a new column, and then use that column to sort.

  X      X      X      X      X      =COUNTA(A1:E1)
  X      X             X      X      =COUNTA(A2:E2)
  X                                  =COUNTA(A3:E3)
  X             X             X      =COUNTA(A4:E4)
  X             X                    =COUNTA(A5:E5)
  X                           X      =COUNTA(A6:E6)

Results in 

  X      X      X      X      X      5
  X      X             X      X      4
  X                                  1
  X             X             X      3
  X             X                    2
  X                           X      2

Then use column F to sort your data.

Related Topic