Does it make a difference if I'm using Vista and Excel 2007?

In Excel 2007 you can use the new IFERROR function:

=IF(ISERROR(LARGE($A:$A,ROWS($1:1))),"",INDEX(wkly !A:A,MATCH(LARGE($A:$A,ROWS($1:1)),$A:$A,0)))

=IFERROR(INDEX(wkly!A:A,MATCH(LARGE($A:$A,ROWS($1: 1)),$A:$A,0)),"")

There are still some situations where a "crafted error trap" is more
efficient than IFERROR.


--
Biff
Microsoft Excel MVP


"Max" wrote in message
...
Does it make a difference if I'm using Vista and Excel 2007?
Don't think so.

Do not change the ROWS($1:1) part in the top cell formula (in B2)
when you adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jeel" wrote in message
...
I got the formula to work in a2:c5, but if I want it anywhere else on the
page
I can't seem to get it to undate correctly. I think I am in way over my
head.
Does it make a difference if I'm using Vista and Excel 2007?
Thank you for your time and help. jeel