A
A
Alina Shah2021-08-19 17:57:34
Google Sheets
Alina Shah, 2021-08-19 17:57:34

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.
611e71e67f27c090701978.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2021-08-19
@Shah_Alina

=FILTER(A:A;A:A<>"")

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question