Ask Your Question
0

Data Table Alternative

asked 2017-07-04 13:15:12 +0200

cranmax gravatar image

updated 2017-07-04 13:18:50 +0200

Hi,

I'm finding an alternative to Excel Data Table, in Excel it appears in Data -> What-if Analysis -> Data Table. This helps me to calculate the results of 1 cell with different values of 1 or 2 variables. I post here a photo to understand it better:

DataTablehttp://imgur.com/a/FxmsK

On the top-left (A1) I write the cell that I want the results, and the row at the right (B1:V1) these are constants that uses the variable_A, below A1, the column from (A2:A22) these are constants that uses variable_B. And the body of the table are the combinations from variable_A and variable_B that gives A1.

Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-07-04 14:13:38 +0200

pierre-yves samyn gravatar image

Hi

Have you tried Multiple Operations?

Regards

edit flag offensive delete link more

Comments

Thanks, I'm looking into it. It seems that the difference is that is not needed to be the function cell in the top left like in Excel. I have some problems in the results, as some are incorrect is like it catches some results from other cells and don't computes it correctly, have you detected it? I'm running on Linux an .xlsx file, but I think this doesn't matter.

Thanks

cranmax gravatar imagecranmax ( 2017-07-04 16:39:17 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-07-04 13:15:12 +0200

Seen: 1,482 times

Last updated: Jul 04 '17