Excel Help

F1Yorkshire

Avatar for sale to the highest bidder
Contributor
Hi Guys (actually mainly aimed at @jez101.xls)

I'm trying to edit my spreadsheet so can get the latest FF1 cup results up and I'm editing some existing formulae with are completely enclosed including the = sign in these brackets: { }

Any time I alter the range in the formula I end up with a VALUE error.

Any ideas?
 
That's a special kind of formula known as an array formula. When you've finished editing it, don't just hit Enter, hit Ctrl-Shift-Enter. Hope that helps. :)
 
I am assuming you have used the curly brackets because it is an array, this can cause problems when editing it is late but I will think about it and get back to you unless someone else gets there first..
 
Back
Top Bottom