View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Art Dameron Art Dameron is offline
external usenet poster
 
Posts: 2
Default Need help with RANK function

This works:

CONCATENATE(RC[2],"Rating")

But this does not work:

RANK(Rate,CONCATENATE(RC[2],"Rating"))

Is it not working because of an error in syntax or is it that you cannot use
an embedded statement like that inside the RANK formula?

Thanks for any help, Art.