Return Array without blanks, zeroes or sorted

[NicBKK]

Hello Gurus,

I have a simple "input area" and I would like in my display area to return data from the input as is, meaning not sorted and skipping blanks

SCR-20230718-qrhq.png

Thanks a lot

[JEC.]

filter(b4:d22,b4:b22<>"")

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

You could try:

=FILTER(B4:D22,A4:A22<>"")