Range names--how to remove?

[yanqui]

At some point, Microsoft Excel decided that the word AVERAGE in an "if" statement was a reference to a range of cells in a column under a column heading "Average." The column heading is typed as I typed it: Average. Every time I try to alter the IF statement by changing Average to AVERAGE, it changes back. I can't find the named range in the define box, as the help screen suggested to do. What did I do and how do I undo it. My workaround was to add the cells and divide by the number of cells instead of using the average function, but I want to know what happened so I don't do it again!

 

[wwgmr]

Hello

Try using ctrl+G and then type in Average see if it takes you to a range. If that doesn't then what I would suggest is maybe put the Average function in () that may allow you not to use it as Range. If it was range it would be in Defined.


Best of luck

Eric

 

[yanqui]

That was helpful information, but when I went back into it, it wasn't doing that same thing. Grrr.

 

[Dreamboat]

Please paste your formula here...

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[yanqui]

if(b3>0, average(c3,f3,i3,l3,o3,r3), average(f3,i3,l3,o3,r3,u3))

it returned a "#null" value, and usually the word "average" is in caps, but in each of the rows where I got the "#null" value, the word "average" was "Average," and when I pressed F2, the highlighted boxes included a column whose heading was "Average". When I did the workaround I referenced, then closed it, whatever it was didn't stick around, because when I went back to try that ctrg+g thing, I typed the formula and it worked. If it happens again, may I email you the sheet? I'm really curious as to why that happened!