=SUBSTITUTE(ADDRESS(1,COLUMN(A1)+MATCH(MIN(A1:C1),A1:C1,0)-1,4);1;"")

HTH
--
AP

"mr_espresso" <mrespresso@discussions.microsoft.com> a écrit dans le message
de news: 15B9A43A-2720-4C1A-8308-7DBB9F9834EC@microsoft.com...
> Excellent! Thank you for that fast reply.
>
> One follow-up question. Is it possible to remove the row number from the
> result so only the column number is returned (e.g. A instead of A1)? This
> is
> important because each column number is going to be relabeled in my stats
> software and I'd like to avoid relabeling 1000's of cell addresses!
>
> Thanks again
>
> "Ardus Petus" wrote:
>
>> Try this:
>> =ADDRESS(ROW(),COLUMN(A1)+MATCH(MIN(A1:C1),A1:C1,0)-1,4)
>>
>> It wille return a cell address, like: A1
>>
>> HTH
>> --
>> AP
>>
>> "mr_espresso" <mrespresso@discussions.microsoft.com> a écrit dans le
>> message
>> de news: 68FA97FC-8C8C-40CE-9F8A-3B221DB888E9@microsoft.com...
>> > Hi folks. For the sample data below, columns A - C contain survey
>> > response
>> > data: 3, 6 and 9. I'm looking for advice on writing a function for
>> > column
>> > D
>> > that would look at columns A - C and return the # of the column
>> > containing
>> > the min value (e.g. A in this example). Thank you in advance!
>> >
>> > A B C D
>> > 3 6 9 A
>>
>>
>>