Ask Your Question
0

Data Table Alternative [closed]

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

cranmax gravatar image

updated 2020-07-24 12:53:15 +0200

Alex Kemp gravatar image

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: activated screenshot)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-24 12:52:47.810614

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

Question Tools

1 follower

Stats

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

Seen: 2,207 times

Last updated: Jul 24