View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Killer Killer is offline
external usenet poster
 
Posts: 80
Default Can't get {} woking

Hey Ron

Here's the formula

=IF(ROWS(1:$1)<=COUNTA(B$13:B$45),INDEX(B$13:B$45, MATCH(LARGE(AM$13:AM$45-ROW(AM$13:AM$45)/10^10,ROWS(1:$1)),AM$13:AM$45-ROW(AM$13:AM$45)/10^10,0)),"")

It woks I know this much but if I edited anything at all I get a #VALUE!
error.

Thanks ahead!

Rob


"Ron Rosenfeld" wrote:

On Fri, 22 Jun 2007 16:04:01 -0700, Killer
wrote:

I tried

CTRL, Shift and Enter and t doesnt add the command that is required is
there something I missing?

Thanks ahead!

Rob


What formula are you committing?
--ron