|  

» Find the last numeric value in a range in Microsoft Excel

Text/Numeric data in column A

A1 	 
A2  	AAA 
A3
A4	BBB
A5	CCC
A6	DDD
A7	502
A8	EEE
A9	
A10

Formula in cell B1: {=INDEX(A1:A10,MATCH(9.99999999999999E+307,A1:A10))}

Result:		    502
Please note: The formula is an Array Formula, after entering the formula in the cell, press F2 and than press Ctrl+Shift+Enter Screenshot // Find the last numeric value in a range in Microsoft Excel
Find the last numeric value in a range in Microsoft Excel


Rate This Tip
12 34 5
Rating: 3.32     Views: 21049
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments