Thread
: [Solved]
What formula can I use to find the lowest cell in a column that has a value in it?
View Single Post
04-20-2016, 09:29 PM
xor
Windows 10
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)
xor
View Public Profile
Find all posts by xor