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

 

[DanteAmor]

This may be an option

Excel Workbook
	A	B	C	D
1
2
3
4		The first cell is		23136913
5
6
7
8
9
10		REPORTE	MONT	QUAN
14		23136913	d	1.9
15		23136914	e	2.2
Hoja3

Array formulas
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

 

[DanteAmor]

Try another way

Excel Workbook
	A	B	C	D
1
2
3
4		The first cell is		23136913
5
6
7
8
9
10		REPORTE	MONT	QUAN
14		23136913	d	1.9
15		23136914	e	2.2
Sheet

Array formulas
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

 

[DanteAmor]

Shorter

Excel Workbook
	A	B	C	D
1
2
3
4		The first cell is		23136912
5
6
7
8
9
10		REPORTE	MONT	QUAN
13		23136912	c	1.6
14		23136913	d	1.9
15		23136914	e	2.2
Sheet

Array formulas
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.