We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Data Table Alternative [closed]

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

cranmax gravatar image

updated 2021-05-27 11:58:57 +0200

Alex Kemp gravatar image


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:


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.


(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

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

pierre-yves samyn gravatar image


Have you tried Multiple Operations?


edit flag offensive delete link more


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.


cranmax gravatar imagecranmax ( 2017-07-04 16:39:17 +0200 )edit

Question Tools

1 follower


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

Seen: 2,798 times

Last updated: Jul 24 '20