How to locate Datatable's formula

luozhan

New Member
Joined
Apr 2, 2017
Messages
2
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
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,339
Office Version
2019, 2016, 2013
Platform
Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,233
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top