How to make a one way data table in Excel

Please SUBSCRIBE:
www.youtube.co...
Excel demonstration of one-way data table
Download the demonstration file:
alphabench.com...
See the Two Way data table tutorial:
• How to make a two way ...

[@TheKingOfHalo]

Thanks. Very helpful indeed.

[@MattMacarty]

Glad it helped

[@geeee8933]

I rewatch every 2 months after I again forget how to do this

[@MattMacarty]

Glad it helps

[@Dennaton]

that's why we have the internet :D

[@GEX_Datos_Finanzas]

Hello Matt, I have a question, do i have to set for Manual Calculation on the Excel adjustments? Regards

[@MattMacarty]

No. Pretty much always leave the calculation setting to automatic

[@djtwister6997]

11 years and I’m working on the same problem as the video, wow can’t believe my text book problem is 11 years old 😂

[@MattMacarty]

Glad it helped

[@esarcheema2738]

hopefully you save my life

[@MattMacarty]

Glad it helped.

[@sokeefe95]

Thank you very much kind sir!

[@MattMacarty]

Glad it helped.

[@dikshamatia1962]

Is it possible to do it on google sheets?

[@MattMacarty]

I don't think there is an extension that does this in Sheets

[@jerodpeters6167]

when i sent this up the data table does not work, it just gives me 11,000 for all the outputs

[@MattMacarty]

It sounds like there is a problem with one of your formulas from the model.

[@zingGodin]

thank you

[@MattMacarty]

Glad it helped

[@zillabeast]

Dude!

[@MattMacarty]

Glad it helped