Thread
:
Returning contents of a cell based upon the minimum value in a ran
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Returning contents of a cell based upon the minimum value in a ran
With your data in A1:C2 try:
=INDEX(A1:C1,MATCH(0,A2:C2,FALSE))
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Shawn" wrote in message
...
If I have:
Apple Lemon Orange
3 0 1
How do I get Excel to look through the row of data, find the minimum (or
specifically, I am looking for the one and only Zero that would be in the
data), and return the cell above it? In this case, the returned value I am
looking for would be Lemon.
Tried =offset(min(range),-1) but I am guessing Excel won't let me use a
formula for the Reference part of Offset.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann