Excel Function in what appears to be an array

[Guest]

I am trying to find what the =UPPER(HPFUL(specified cell,"name")). I know
what the upper is for but not sure what the HPFUL is for. It looks like it
may represent some table that I cannot find on the worksheet matching the
specified cell content to a table array, which again I cannot find. Can any
one help with this. Thanks

 

[Arvi Laanemets]

Hi

As there are 2 parameters for HPFUL, it looks like you have an UDF (User
Defined Function) in your workbook. You can check for it activating function
wizard, and looking for HPFUL under categorie 'User Defined'.

To see UDF code, press Alt+F11, and check workbook's modules.


Arvi Laanemets

 

[Guest]

You might try <tools><Formula Auditing><Trace precedents> This should lead
you to where it is.
It is also probable it is a user defined function.
click on the fx next to the editing bar and look for catagory that may be
called user defined or some such title. If it was saved with the Workbook,
it would be in one of the modules. IF it was saved on the developers
personal workbook, youwoul have to go to that person to find what it meant.

 

[Kemal Pamuksuz via OfficeKB.com]

Hi,

There is an UDF of Hyperion Retrieve add-in as part of Hyperion Reporting
Software called HPFUL. It is used for getting the full name of an reporting
entity. HPFUL(Entity Name, Application).

Hope that helps

Kemal Pamuksuz