Forum Discussion

Marc_Kim's avatar
Marc_Kim
Copper Contributor
Sep 26, 2023

How can get a value of the first row according to filter selection?

Hi all,   I would like to get first row of text every time I filter row.    e.g. when Update Period selected 2023-06, then capture the first row# 22. when Update Period selected 2023-07, then ca...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Sep 26, 2023

Marc_Kim 

A 365 solution.

 

=LET(
    VisibleOnly, LAMBDA(element, IF(SUBTOTAL(3, element) = 1, element, "")),
    visible, MAP(Table1, VisibleOnly),
    filtered, FILTER(visible, TAKE(visible, , 1) <> ""),
    TAKE(filtered, 1)
)

 

Resources