If the columns used are always only A, B or C:

=CHOOSE(MATCH(MIN(A1:C1),A1:C1,0),"A","B","C")

Biff

"Ardus Petus" <ardus.petus@laposte.net> wrote in message
news:u4BH9qilGHA.1204@TK2MSFTNGP02.phx.gbl...
> =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
>>>
>>>
>>>
>
>