First in selection

  • Thread starter Thread starter Arjen
  • Start date Start date
A

Arjen

Hello,

I have this selection:
-
12345
215489996
25845598523364

This is also posible:
-
-
215489996
25845598523364

Now I want to know/select the first number. In the first case this will be
12345 and in the second 215489996.

How can I do that?

Thanks!
 
Hi
try the array formula
=INDEX(A1:A10,MATCH(TRUE,ISNUMBER(A1:A10),0))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

working with length formula 3
How to replace text with numbers? (formula) 3
Vlookup cells in combination of two columns (both in the lookup value AND table array) 3
Help with converting data in Excel 6
Combining equal rows 2
SEARCH and LEN 7
regular expression 7
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1

Back
Top