Re: an inverse to the address() function?



On Sun, 2003-05-11 at 20:59, Dan Drake wrote:
I want to type in a column name and have the cell below it automatically
return the column number.

=column(indirect(A1&"1"))

- olly




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]