Find first numerical value in the column

[Berna11]

Good evening, as the title would need to find in the first column P numerical value not text.
I used:
= MIN (P3: P100) and gives me the result.
But, If the values are not in order. what other formula used ?.
Thank you

[AlKey]

Try this

Please Login or Register  to view this content.

You may need to change commas to semi-colon

[Berna11]

Perfect, AlKey that's fine
thank you

[Tony Valko]

Here's another one...

Array entered**:

=INDEX(P3:P100,MATCH(TRUE,ISNUMBER(P3:P100),0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[Berna11]

thank you Tony Valko

[Tony Valko]

You're welcome!