Hi jb,

The 'TABLE' function is not a standard Excel function, but rather a custom function that has been created using VBA (Visual Basic for Applications) code. This is why you are not able to get it to work outside of the file you were sent.

To use this function, you would need to have the VBA code that creates the function available in your Excel workbook. This could be in the form of an

1. add-in or
2. macro-enabled workbook

that you would need to open and enable in order to use the function.

Without access to the VBA code, it is not possible to recreate the 'TABLE' function in a new workbook. If you need to use this function, you will need to obtain the original file or contact the person who created it to get more information on how to use it.

I hope this helps clarify things for you. Let me know if you have any other questions!