Forum Discussion

Copper Contributor

Oct 27, 2022

Solved

Skip blanks and list

Hi there I want to try and make my work a bit easier by making a list of drawings automatic populate sheets by marking them "x". Drawings nr. in column H. I would like a list as sho...

Formulas and Functions

OliverScheurich
Oct 27, 2022
KasperHH
=FILTER(H8:H14,M8:M14="x")
You can try FILTER function.

PeterBartholomew1

Silver Contributor

Oct 27, 2022

KasperHH

This may not be what you require, but it is possible to unpivot the entire array with a single dynamic array formula.

= LET(
    a?, mark="x",
    r,  IF(a?, rev,NA()),
    d,  IF(a?, dato, NA()),
    HSTACK(TOCOL(r,3,1), TOCOL(d,3,1))
  )