How to find the first numeric cell in an Excel range?
If there is a list of data mixed with text and numbers, how can you quickly find the first numeric value as below screenshot shown in Excel? Here I have a formula that can quickly handle it without manual checking.
quickly convert multiple XLSX. files to XLS or PDF. files in once time
|In many cases, you may want to convert between XLSX and XLS, or convert a workbook to PDF file, but in Excel, you only can convert one workbook once time, have you ever imaged to convert multiple workbooks at once time? With Kutools for Excel's File Format Converter, you can quickly convert multiple workbook to pdf/97-2003 workbook/2007 or higher workbook at once and save them in a folder, at the same time, a converted report is generated! Click for 60 days free trial!|
|Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days.|
To find the first numeric cell which includes times, dates and numbers, you can use this formula:
Select a cell which you place the finding result, type this formula =INDEX(A1:A10,MATCH(TRUE,INDEX(ISNUMBER(A1:A10),0),0)), and press Enter key.
Now it returns the actual value of the first numeric in the specified list. See screenshot:
Note: In the formula, A1:A10 is the specified list you will check for the first numeric value from, and you can change it as you need.