Is there an excel add-in for table functions?

[odincer]

Since weeks I am looking for an add in for table valued function but I couldn't find any... Could you recommend me some add ins that can help me to make operation with excel tables?

 

[Smitty]

Welcome to the Board!

Jon Acompora has a table add-in here.

HTH,

 

[odincer]

Thanks for your fast reply.

I checked the page you have given but couldn't find an add-in for table functions. Which one do you mean?

I need an add-in for analytical table operations like aggregation, allocation, distribution, multiplication and so on...

 

[Smitty]

Jon's table add in is the Absolute Reference Add-in one. I don't know of anything specifically targeted toward your needs though.

 

[odincer]

I checked the add-in you mentioned, it is only about referencing excel tables in worksheet formulas (toggling between relative and absolute references etc.). This is not I am looking for. I am looking for a solution to implement table valued functions in excel such functions are often used in business intelligence for planning or forecasting.

 

[Smitty]

Have you looked at DAX functions?

 

[odincer]

DAX functions are fine but they are only about aggregation and filtering of data tables.

After some research in internet I came across an excel add-in for table valued functions which seems to have broader features including table arithmetic and distribution. This is apparently a new add-in in its beta stage. I will test this add-in and I wonder if anyone has already experience with it.

 

[royUK]

Ron de Bruin has one

Table Tools Add-in for Excel 2007-2013