The most important upgrade in Excel 2007

[Angelicus]

Dear all,

Which functions do you think Microsoft Excel 2007 had improved most drastically and that you've found the most useful?

Please share .

 

[DonkeyOte]

In my mind THE function that MS have FINALLY added that they should have added a long, long, long time ago is IFERROR, previously you had to double evaluate else use a UDF to avoid, the IFERROR is essentially the UDF we've all probably coded which namely evaluates result of a formula and returns an alternate value if the result is an Error value.

Before:

=IF(ISNA(MATCH("Test",A1:A4,0)),"Error",MATCH("Test",A1:A4,0))

Now:

=IFERROR(MATCH("Test",A1:A4,0),"Error")

 

[schielrn]

For people in my office the ability to sort and filter by color. People here love to highlight things and then they use to hold down control and select everything they highlighted to make sure they have the right sum. Now they can just filter on it.

Then I also love the people that tell me:

"Now I can finally sum and count based on more than one condition. Its about time Excel has allowed for that functionality"

 

[RoryA]

The most important upgrade in Excel 2007?
Service Pack 1!!

 

[schielrn]

The most important upgrade in Excel 2007?
Service Pack 1!!

Which my work still has not pushed to me. I was going to download it myself, but they keep telling me it is coming.