What formula can I use to find the lowest cell in a column that has a value in it?

		Microsoft Office Forums > Microsoft Excel > Excel
What formula can I use to find the lowest cell in a column that has a value in it?

04-20-2016, 09:29 PM

xor

Windows 10 What formula can I use to find the lowest cell in a column that has a value in it?

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

If you have your numbers in A1:A100 then

Last value: =LOOKUP(2,1/(A1:A100<>""),A1:A100)

Address of last value: =ADDRESS(MATCH(9.9E+307,A:A),1,4)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If column B cell is a certain value then copy and paste the value to column A	Snaybot	Excel Programming	1	12-01-2015 07:10 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Find text within cell and return column and row title next to the name on a new sheet.	tanyabowring@live.co.uk	Excel Programming	2	03-26-2015 01:48 AM
keep each item/cell in column A associated with a group in column C	ht889	Excel	1	02-25-2014 12:36 PM
How can I delete the content of a cell in column if the cell value is more than 1000?	Learner7	Excel	2	06-27-2011 05:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:48 AM.