• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hidden Function in Excel

Asheesh

Asheesh

Excel Ninja
Hi Guys -

I am just wondering, are there any more hidden functions in excel that you are aware of other than the ones listed below..well I am talking about version 2007 or below

1) Aggregate
2) DatedIf
3) Evaluate
 
Hi Asheesh ,

There seems to be some confusion here ; if you mean Excel 2007 and below as you have posted , then AGGREGATE does not fit in.

If you mean Excel 2010 and above , since AGGREGATE is not available in Excel 2007 and below , then AGGREGATE is a well-documented function , unlike the other two. DATEDIF is undocumented , while EVALUATE is not just undocumented but even obsolete. And like EVALUATE there is a complete list of Excel 4.0 macro functions which are still available in later versions of Excel.

By undocumented I mean not documented in the official Excel help.

By obsolete I mean unsupported by Microsoft.

See the following links for more information on Excel 4.0 macro functions :

http://www.microsoft.com/en-in/download/details.aspx?id=19243

https://support.office.com/en-in/ar...bb2-8d76-2c07ff02e0b8?ui=en-US&rs=en-IN&ad=IN

Narayan
 
You must log in or register to reply here.
Back
Top