Formula to display the contents of the first filtered cell

[tinkode]

Hello kings i want

A Formula to display the contents of the first filtered cell


Exemple like this pic

 

[Prish]

Assuming on column B with 13 rows, you can use the following array formula (press the Ctrl + Shift + Enter keys)

=INDEX(B2:B13,MIN(IF(SUBTOTAL(3,OFFSET(B2,ROW(B2:B13)-ROW(B2),0)),ROW(B2:B13)-ROW(B2)+1)))

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1087788-show-number-filter.html#post5227695

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).