I much prefer working in Excel 2007 to Excel 2003. Despite the issues with backward compatibility, there are a lot of advantages and benefits to using the new version.
Some little things that have been changed are
The previous limit on nested brackets in formulas from 7 has been increased to 64. I used this today
The number of columns and rows has increased. I used this today.
I had to develop a file for a client that involved a complex work roster arrangement to calculate days off in repeating 2, 3 or 4 week cycles for the next 20 years.
Here is the nested formula that got me the logic for a roster.
=IF($X5>=AJ$4,$X$4,IF($Y5>=AJ$4,$Y$4,IF($Z5>=AJ$4,$Z$4,IF($AA5>=AJ$4,$AA$4,IF($AB5>=AJ$4,$AB$4, IF($AC5>=AJ$4,$AC$4,IF($AD5>=AJ$4,$AD$4,IF($AE5>=AJ$4,$AE$4,IF($AF5>=AJ$4,$AF$4,$AG$4)))))))))
I then used one formula to generate over 600,000 cells and create a map that looks like this.
Recent comments
9 years 46 weeks ago
9 years 46 weeks ago
9 years 47 weeks ago
9 years 47 weeks ago
9 years 47 weeks ago
9 years 47 weeks ago
9 years 47 weeks ago
9 years 47 weeks ago
9 years 47 weeks ago
9 years 47 weeks ago