Answer the question
In order to leave comments, you need to log in
How to display only filled cells?
https://docs.google.com/spreadsheets/d/1kA10XbhcO7...
In the yellow column, some cells received data.
The task in the next green column is to display these cells in a column in order, I attach the screen for clarity in the blue column.
Green field in the table for entering the received data.
Filter via "Menu/Data" is not an option.
Or transform the existing formula in I1
=IF(G2>0;IF(H2>0;A2;"");"")
to extend to cells I2-I21 and filter (display) in a list, i.e. no empty cells.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question