View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike K Mike K is offline
external usenet poster
 
Posts: 104
Default Cant get dynamic range formula to work.

Biff,
Forgive me for my blunder. I copied the formula in a partially
modified state. It should be:
=INDEX(P:P,LARGE(IF($P$7:$P$65535<"",ROW($P$7:$P$ 65535)),ROW($AM$17)-ROW()))

I've got it working now.

Thanks,
Mike