Catagory function

dmz

Board Regular
Joined
Apr 20, 2005
Messages
59
This is an excel 97 question.

When I select insert, then function. In the list I have a blank name that has a set of functions.

Can anyone help how to name or delete it.
[/url]
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
Where is the blank name located in the list? What are the names of the functions in the blank category?
 

dmz

Board Regular
Joined
Apr 20, 2005
Messages
59
The blank category is after UDF abd before engineeing. Some functions from engineering are dulplicated in the blank category
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
It sounds as though you've had problems with an add-in. Try removing all add-ins, and restarting Excel, and seeing if the blank category goes. If that doesn't fix it, then I'd recommend re-installing Excel.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,377
Members
412,589
Latest member
ArtBOM
Top