How to locate Datatable's formula

[luozhan]

Hi all,
I know how to use What if Analysis to create a Datatable. When I look at others' excel model, I saw =TABLE(P12,S10) in the cell. I know it's a Datatable using two variables. My question is how to locate that formula in the workbook. How do I know what formula the Datatable using? Many thanks!

Best regards,
Leo

 

[mole999]

Happy to be proved wrong, (2010) doesn't seem to have a cell formula called TABLE, so I would be guessing that this is a UDF within the macro

 

[luozhan]

Happy to be proved wrong, (2010) doesn't seem to have a cell formula called TABLE, so I would be guessing that this is a UDF within the macro

It's Datatable and it's in Excel 2010. Check out this Youtube: https://www.youtube.com/watch?v=jSA8OtB4zi0