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-19-2016, 08:50 PM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,101
If you have your data where you want to find the lowest value in C1:C20 and the data you want something returned from in A1:A20 then try the following formula:
=INDEX($A$1:$A$20,MATCH(MIN($C$1:$C$20),$C$1:$C$20 ,0))
xor
View Public Profile
Find all posts by xor