Forum Discussion
Marc_Kim
Sep 26, 2023Copper Contributor
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...
SanthoshKunder
Sep 26, 2023Iron Contributor
Marc_Kim - How about a helper column with COUNTIF formula?. Filter only 1 gives you the first result from the list of values.