View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ellebelle ellebelle is offline
external usenet poster
 
Posts: 34
Default CHAR funtcion with double letter columns

I am using this function:

CHAR(MATCH(P$1,$1:$1,)+64)

to get teh column letter, however it does not count double letters past
column z. As in AA AB etc.

Is there a way to get this?

Ellen